Work with hours and minutes in Excel 2007
Fresh3 days ago
Mar 15, 20268594 viewsConfidence Score0%
0%
Problem
I'm working on a spreadsheet that holds phone calls durations. So, each call (row) has a value like 00:01:30, 01:02:12, etc. When I sum the duration column, it will give me something like 687:23:42. That's OK. But, my carrier charge us by minutes. So, I need to convert the above total to minutes. H…
Error Output
=hour(a1)
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Work with hours and minutes in Excel 2007
Low Risk
Excel stores times as a decimal part of the day, so 1 hour=1/24=.04167 To convert that number to minutes multiply by 1440. 1440 is derived by multiplying the number of hours in a day (24) times the number of minutes in an hour (60). So the 687:23:42…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix