MS Excel Date and Time Addition

  • Thread starter Thread starter ulrichd
  • Start date Start date
U

ulrichd

I have to run an automated test 20,000 cycles. I know that it runs 6
cycles per minute. How can I get Excel to calculate the completion
date/time if I enter the start date/time in this format?

Start: 7/18/03 12:00 AM
Cycles: 20,000
End: ??? (assume 24x7)

Without Excel, I would simply do the following:

Cycles 203129
Minutes 33855 based on 6 cycles per minute
Hours 564.2
Days 23.5

Jul 18 plus 23.5 days is X

Thanks - Dan
 
How about:

=A1+(A2/6/60/24)

A1 = Start
A2 = Cycles

Format as date/time.

a2/6 = number of minutes
/60 = number of hours
/24 = number of days

And you can just add a number to a date and get the end date. (If you format it
nicely.)
 
Back
Top