Making fraction of hours with a comma seperator in Google Sheets-CodePudding

Home > Mobile > Making fraction of hours with a comma seperator in Google Sheets

Making fraction of hours with a comma seperator in Google Sheets

Time：04-20

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

CodePudding user response：

duration:

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

decimal:

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