Sunday, February 3, 2013

yogi_Compute Row By Row Time Difference Between EndTime And StartTime And Display Result In hh.mm.ss


                                          Google Spreadsheet   Post  #1009
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 03, 2013
post by user: Antti Ranta said:(http://productforums.google.com/forum/?zx=fd3vq3iqu592#!category-topic/docs/spreadsheets/sblroaCXwC8)
How can I calculate timedifference in 24 hour format in sheets?
Hi,

I'm trying to get my working hours in "hh:mm:ss" format when start and end date format is "YYYY-mm-dd hh:mm:ss". I use =TEXT(B2-A2; "hh:mm:ss"), but it always gives 12 too many hours if the difference is less than hour long. For example if difference is 33 minutes, I get 12:33:00 :( 

I have set the spreadsheet locale settings correctly. Please help, I'm pissed off

---
Ok, I came to conclusion that this program cannot calculate anything. It cannot convert seconds to time, it cannot convert hours to time, it cannot calculate time difference correctly, it cannot sum time values... used 3 hours and now I've had enough of this
---
Here is a sample data that I get from work clock program:
https://docs.google.com/spreadsheet/ccc?key=0Ag_XYcNmpTDJdE1Fd3pKZVMwLThJaWFMX0xYbDFFUGc&usp=sharing

By default I get every other column from the program except hours column. Income column has also the hours but in wrong format. I need the total hours in format "hh:mm:ss". I have put the formulas into the spreadsheet. 

Thank you for trying to help. I'm stuck using this work clock program now that I have many records in there already, and I'm not going back to excel sheets

-----------------------------------------------------------------------------------------------------------
it is a simple problem of computing the difference between column B values and column A values ... however, since the use is having so much difficulty with it, I am providing the following illustration