How do you add time?

  • Thread starter Thread starter Ergo Rider
  • Start date Start date
E

Ergo Rider

How do you add time?

This is what I have now 7:00A.M. 12:00P.M. 12:30P.M. 3:30P.M. = 11:00P.M.

This is what I would like 7:00A.M. 12:00P.M. 12:30P.M. 3:30P.M. = 8 HOURS
TOTAL
 
Hi
assuming your numbers are in the range D5 to G5

=((E5-D5)+(G5-F5))*24

format as number (if required)

Hope this helps
Cheers
JulieD
 
Ergo,

With Start, stop, start stop in columns B to E:

=(C2-B2)+(E2-D2)

The parens aren't needed -- they're for clarity. Format for time as needed
(Format - Cells - Number - Time or Custom).

Or if you want fractional hours (7.5 instead of 7:30):

=((C2-B2)+(E2-D2)) * 24

Format for number, not time.
 
Back
Top