time

[lydia]

is it possible to have a formula that calculates time
that crosses midnight? for example, if the job starts at
10:00 p.m. and ends at 1:00 a.m., how do i calculate the
elapsed time.
tia

 

[Arvi Laanemets]

Hi

With start time in A2 and end time in B2
=B2-A2+(B2<A2)

 

[lydia]

thanx

-----Original Message-----
Hi

With start time in A2 and end time in B2
=B2-A2+(B2<A2)


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)






.