With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, July 20, 2012
yogi_Compute Elapsed Time Row By Row From A Table Of From To Clock Hours
I have been using the same formula and it has been working fine. Today, I'm getting an odd result and the formula has not changed.
The data below are 2 rows of times and a third row of hours and minutes lapsed.
The formula is in col. C but the row numbers change as you go down. The formula below is what is in cell C4.
15:50 - 02:30 should equal 13 hours and 20 minutes but on the sheet it comes out to 1 hour 20 minutes. From typing this out it looks like I can see where the 1:20 result is coming from, but why is it doing that? I need it to show the full 13 hours and 20 minutes.