Google Spreadsheet Post #2470
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Jul-01-2018
question by: signage
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/UuqeHacc9LU;context-place=forum/docs
Converting Minutes to Hours and Minutes
I track my daughter's chores relative to time within Google Sheets. We use minutes to update the amount of time she earns and spends (e.g. she earns 30 minutes for cleaning her room or uses 60 minutes to play a computer game). But for subtotals on earnings and spending as well as the total balance available, it would be better to display times in terms of hours and minutes. I've tried a few different solutions but they all seem to come up short when trying to account for all factors like negative time, time in the single digits, whole hours without minutes, etc. This spreadsheet of blasphemous formulas seems to handle all the variations of counting up time that I need (in context of HH:MM) but I was wondering if there's a way to simplify the number of formulas.
https://docs.google.com/
Appreciate your help in advance!
125 KB
No comments:
Post a Comment