Excel help wanted

[bryanm]

I am trying to setup a roster using 24 hour time format. Just need to know how to do the following. I have a start
time and a finish time showing on the same day. No problem here. When I want to show a start time on one day and a
finish time on a different day is where my lack of knowledge shows up. Here is an example of how I started.
=G10+(G9>G10)-G9 This formula is in a different cell and adds the daily hours.
G9 is the start time and G10 is the finish time. To do a shift that spans midnight I need the formula to say, G9
will be start time, if nothing in cell G10 look at cell H10 for finish time and total the hours.

 

[T. Valko]

I am trying to setup a roster using 24 hour time format. Just need to know how to do the following. I have a start
time and a finish time showing on the same day. No problem here. When I want to show a start time on one day and a
finish time on a different day is where my lack of knowledge shows up. Here is an example of how I started.
=G10+(G9>G10)-G9 This formula is in a different cell and adds the daily hours.
G9 is the start time and G10 is the finish time. To do a shift that spans midnight I need the formula to say, G9
will be start time, if nothing in cell G10 look at cell H10 for finish time and total the hours.

One way...

=MOD(IF(G10="",H10,G10)-G9,1)

 

[bryanm]

Thankyou very much. This is exactly what I needed.

 

[T. Valko]

Thankyou very much. This is exactly what I needed.

You're welcome. Thanks for the feedback!