Thursday, April 25, 2013

yogi_Time Calculations When Some Times Are Not In The same Day


                                          Google Spreadsheet   Post  #1154
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 25, 2013
user Jason Nargi :(http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/Y0z1gCqSanQ)
Tallying times in sheets
We use sheets to track operating times for a small business jet.  We use the 24 hour clock (UTC) to calculate times which we then convert into tenths (1:30=1.5). At present we calculate times that go over the 2400 mark by assuming that there are 25 hours in the day.  An example of the problem would be to tabulate a time starting at 2230 and ending at 0030 the next day.  How can we write the formula to tabulate the time when it goes past 2400?  Thanks
---

In columns D, E and F we are inputting start times in 24 hour format.  In columns H, I and J we are inputting end times in 24 hour format.  Example; H1 - F1 = L1. In order for us to make it work we have to write the hour 0110 as 2510.  We would like a formula that resolves the need to write the number as 2510 instead of the actual time 0110.
Thanks
Jason

-------------------------------------------------------------------------------------------------------------------------------
here we go