Subtract 7:00 pm from 7:30 pm

[Rohit Thomas]

Larry,

You can also input the start and end time using military
time, which would require no formatting.

Using your example:
A1(Start) A2(End) A3 = (A2-A1)(Diff/Total)
19:00 21:45 2:45

Hope that helps,
Rohit