'Making fraction of hours with a comma seperator in Google Sheets

Looking to make a fraction of an hour format with commas I've tried to format but couldn't figure out how, if anyone can help it would be appreciated

the image

Like Hour,FractionOfHour

New Image: New Image that shows the spreadsheet

google-sheetstimesumnumber-formattingduration


Solution 1:[1]

duration:

=IFERROR(1/(1/(SUM(F3:J4)/60/24)))

enter image description here

decimal:

=IFERROR(1/(1/(SUM(F3:J4)/60)))

enter image description here

demo sheet

Solution 2:[2]

Not sure if I understood your question correctly, but here is the solution to display the time as a decimal

=HOUR(A1)+MINUTE(A1)/60+SECOND(A1)/3600

or

= TIMEVALUE(A1) * 24

where in cell A1 is time

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0
Solution 2

Related Questions