Sunday, July 1, 2018

yogi_Convert Time Imn Minutes (positive and negavive) Into Hours and Minutes

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.


Appreciate your help in advance!
Screen Shot 2018-07-01 at 4.54.38 PM.png
125 KB