Calculate time counting up

  • Thread starter Thread starter rtaylor327
  • Start date Start date
R

rtaylor327

Hello

I have 4 columns in my spreadsheet.

StartDate StartTime EndDate EndTime *ElapsedTime*
06/01/2004 07:00 AM 06/07/2004 07:00 PM 127h 30m

What I need is some way to calculate the hours, minutes in between th
two times like a countdown or count up. I have to monitor it so if i
gets over 100 hours it will become critical. I can calculate the i
between time but i need it to count itself down or up. I hope thi
makes sense
 
I figured out how to get the hour difference between the dates and time
Now I need to be able to count down from the humber of total hours dow
to zero

StartDate StartTime EndDate EndTime ElapsedTime
06/01/2004 07:00 AM 06/07/2004 07:00 PM 180:00:00

What I now need is to countdown from 180:00:00 to zero. So I hav
180:00:00 to complete the task and I want to be able to track the tim
I have left.
My cells are A1 B1 C1 D1 E1

Thanks
Bo
 
Back
Top