Timing for an event longer than 24 hours
 

I would like to set up a timer that can go over 24 hours. I currently have a
timer that uses now()-start time but this goes back to 0 after 24hrs. Is it
possible in Excel to get a timer that will show say 25:00:00 at the 25 hour
mark.

Thanks

Timing for an event longer than 24 hours
 

Format Custom as [hh]:mm:ss

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"NDBC" wrote in message
...
I would like to set up a timer that can go over 24 hours. I currently have
a
timer that uses now()-start time but this goes back to 0 after 24hrs. Is
it
possible in Excel to get a timer that will show say 25:00:00 at the 25
hour
mark.

Thanks

Timing for an event longer than 24 hours
 

format the cell as [h]:mm:ss

--
__________________________________
HTH

Bob

"NDBC" wrote in message
...
I would like to set up a timer that can go over 24 hours. I currently have
a
timer that uses now()-start time but this goes back to 0 after 24hrs. Is
it
possible in Excel to get a timer that will show say 25:00:00 at the 25
hour
mark.

Thanks