Total Time

[Klimaks]

I have the situation as seen in the attachment. Now I need the amoun
of time (hours:minutes) between the first start time and the last sto
time.

I know the cell address of the first start time and can find the las
stop time with vertical search. Now I could substract the start time o
the stoptime, BUT for one reason. It is possible the stop time is on th
next day or the day after the next day or ...

How can I solve this. (If it is even possible

+-------------------------------------------------------------------
|Filename: ss.JPG
|Download: http://www.excelforum.com/attachment.php?postid=2660
+-------------------------------------------------------------------

 

[Frank Kabel]

Hi
no valid link. But you may post your question as plain
text. always better than attaching files

-----Original Message-----

I have the situation as seen in the attachment. Now I need the amount
of time (hours:minutes) between the first start time and the last stop
time.

I know the cell address of the first start time and can find the last
stop time with vertical search. Now I could substract the start time of
the stoptime, BUT for one reason. It is possible the stop time is on the
next day or the day after the next day or ...

How can I solve this. (If it is even possible)


+--------------------------------------------------------- ----------+
|Filename:

ss.JPG |

 

[Arvi Laanemets]

Hi

With start time (NB! in vald time format) in A1 and end time in B1
=(B1-A1)+(B1<A1)
and format as time. It works until result is less than 24 hours.