Search code examples
google-sheetstimesumnumber-formattingduration

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


Solution

  • 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