Funky Time Calc

crosseyedanddrueling

Board Regular
Joined
Feb 8, 2007
Messages
178
I have a report that dumps processing times into an excel sheet. The trouble im having is that the format that our time tracker uses is pretty difficult to read....it formats processing times into whole hours then by fractions of an hour so 2.631666 would translate into 2 hours 37.9 min. (.631666*60=37.9)

For each time entry I have to manually multiply the fraction of an hour by 60 to get the minutes and then add it the hours to get the final total.

Question: Is there a way to format exel to read this and translate it into a more readable format....
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
To convert your number to time:
Divide 2.63166 by 24 and format cell as time.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,567
Messages
5,596,907
Members
414,110
Latest member
docops

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