format help

[Eastsider]

Need a little help. I’m trying to do a database using excel and have no clue to set up the formula. Below is the example of what I’m trying to do.

C2 D2 E2 F2 WILL BE THE TOTAL ELAPSED TIME
Dispatch Time En-route Time Arrival Time Total Time
10:00 10:05 10:15 00:15

[daddylonglegs]

If despatch time is in C2 and arrival time in E2 then total time should just be

=E2-C2

format as h:mm

although if C2 may be before midnight and E2 after then this formula will accommodate that too (and ordinary times

=MOD(E2-C2,1)

format as h:mm