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
---
Explanation;
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
No comments:
Post a Comment