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.

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.

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.

Since XL stores times as fractional days, you can use XL's conversion of
TRUE/FALSE to 1/0, respectively, to add 1 (day) if the times span
midnight:

A1: <start time
B1: <finish time
C1: = B1 - A1 + (B1<A1)

An alternative that does the same thing:

C1: =MOD(B1-A1,1)


In article ,
"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.

Thx heaps everyone

way cooler way of doing it

Mark.