Converting time to decimal
Hi
=FinishTime-StartTime+(FinishTime<StartTime)
Replace StartTime and FinisTime with proper cell references. It works fine
when time interval remains <24 hours.
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
"NoodNutt" wrote in message
...
Hi all
I can easily work the time calculation:
Start Time: Mon 00:01AM
Finish Time Mon 23:59PM
How do I calculate time past midnight into the next day so it = 11:00
hours.
Start Time: Mon 21:00PM
Finish Time: Tue 08:00AM
TIA
Mark.
|