Log In
Register
Home
New Member
November 19, 2019
Offline
I'm trying to work out total weekly hours and minutes in excel but when i add the numbers up they come to something like 8 hours 85 mins . why is this?? is there a way to add a formula to get the correct calculation to convert from decimal
For example . 9.38 + 8.06 + 7.45 + 8.00 = 32.89 ??
Thanks for any help
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Paul,
in Excel, 1 day=1 unit, half day =0.5 units.
1 hour=1/24=0.041666667
=32.89/24 will give you 1.3704 days.
If you format the cell with this formula: =32.89/24 with a custom format ([h]:mm:ss), you will see the value in a time format: 32:53:24
The number in cell will still be 1.3704, even if you see it formatted as 32:53:24, so you have to keep this in mind if you need to make other calculations.
VIP
April 21, 2015
Offline
And for some more information this oldy from Mynda here on the website: https://www.myonlinetraininghu.....ion-tricks
Frans
1 Guest(s)
