Total count in days, hours and minutes

Green1972

Board Regular
Joined
Dec 8, 2008
Messages
160
Hi all. I've been away for a while but back now.
I have a Excel sheet that calculates my drone pilot hours. I have a formula that calculates my flight hours over the last 60 days (CAA requirement). What id like to do is be able to do is show my total flight hours, starting from the beginning of the column, formatted in either hours, min, seconds (with out resetting the hours when it get to 23.59.59) or in days, hours and minutes. How would I do this?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
12,013
Office Version
  1. 365
Platform
  1. Windows
formatted in either hours, min, seconds (with out resetting the hours when it get to 23.59.59)
With a custom format of [h]:mm:ss

Your second choice would not be possible with proper times. It could be done but there would be a lack of accuracy in the results.
 

Green1972

Board Regular
Joined
Dec 8, 2008
Messages
160
Thank you. I tried the option and it works. At least with the hours i can work out the days. Thank you very much
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
12,013
Office Version
  1. 365
Platform
  1. Windows
If having days in one cell and hours (part day only) in another is acceptable then you could use
=INT(A1) formatted as number and =MOD(A1,1) formatted as time, where A1 contains the original sum of hours.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,456
Messages
5,601,772
Members
414,472
Latest member
Chris_1990

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