Converting time to decimal
A1: start time
A2: end time
=MOD(A2-A1,1)
"NoodNutt" wrote:
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.
|