Summing Time into Days:Hours:Minutes

jrandol

New Member
Joined
Feb 16, 2004
Messages
22
I asked a question yesterday about how to change decimal numbers into time and know I need to know how to SUM the time into total number of days, hours, and minutes.

For example, if I have B1 to B4 filled with 6:15 (being 6 hours and 15 minutes) when I go to sum them in B5 it says 1:00 hour.

Instead of it only saying the next days hour I need it to say 1 day and 1 hour.

How do I do that?

Thank you!
JR
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

jrandol

New Member
Joined
Feb 16, 2004
Messages
22
Never mind I figured it out. Just thinking too much!


I think you just format the cell to dd:hh:mm.
 

jrandol

New Member
Joined
Feb 16, 2004
Messages
22
Ok. That is not how I need the cell formatted.

I need it to be total hours and minutes. No days! For example in the first post I said 1 day 1 hour. I need it to say 25 hours.

Can anyone help!

Thanks!
JR
 

Ekim

Well-known Member
Joined
Jun 30, 2002
Messages
1,416
JR,

If you want total hours, use [h]:mm.

Also, try these custom formats:

d“day” h“hour” m“minutes”
Will give you: 1day 1hour 0minutes

or:
d\d h\h m\m
Will give you 1d 1h 0m


HTH

Mike
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,322
Messages
5,769,448
Members
425,547
Latest member
Iano

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top