Quick guide
Try an example
You enter
- Duration (H:MM or H:MM:SS)
1:30
You get
1.5
How it works & limits
Enter hours and minutes as H:MM, or include seconds as H:MM:SS. Hours can have up to six digits. The result uses up to 12 significant digits.
Turn hours and minutes into a decimal for a timesheet or spreadsheet.
Numbers Stateless1:30
1.5
Enter hours and minutes as H:MM, or include seconds as H:MM:SS. Hours can have up to six digits. The result uses up to 12 significant digits.