Adding hours & minutes

I want to add hours and minutes in excel.
However when going over 24, the spreadsheet doesn't know what to do.

Example:
13:30 + 2:45 + 11:15

I tried changing the formatting to Time > 37:30:55 and it gave me 339:30:00
The cells that contain the time are calculated cells, which calculate the difference between two times of the day
The formatting for those cells is Time > 13:30

Microsoft OfficeMicrosoft ExcelMicrosoft Applications

Last Comment

itkamisama

8/22/2022 - Mon

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

11/8/2010

Hello,

you need to format the result with

[hh]:mm

note the brackets! Otherwise, Excel will interpret everything above 24 hrs as a day.

cheers, teylyn

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

11/8/2010

See attached. Cell A1 has custom format [hh]:mm

cheers, teylyn
Book2.xls

barry houdini

11/8/2010

If you add those 3 times and get 339:30 then [at least one of] the individual times must be higher than 13:30, 2:45 and 11:15.
Try formatting everything with the 37:30:55 format (which is essentially the same format as teylyn's suggested [h]:mm)
Are the values what you expect? If not then there is possibly something wrong with the formulas you are using to calculate the time difference. Can you post a sample formula?
regards, barry

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

itkamisama

11/9/2010

ASKER

I still can't get it to work
I am enclosing the spreadsheet. Maybe it makes more sense that way.
contractTimes.xlsx

ASKER CERTIFIED SOLUTION

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

11/9/2010

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.