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
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