Saturday, January 10, 2015

yogi_Work With Displaying Hours Minutes And Seconds With 60 Minutes Shown As 60 Minutes Rather Than An Hour

             Google Spreadsheet   Post  #1880
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-09-2015
post by  Bon H:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/9kfBfWLGmPc
How can I stop the spreadsheet from rounding my times up?
I need to enter 89:60:00 into a cell, but it immediately changes to 90:00:00. Have tried everything I think of to do with formatting cells, but nothing works. Works fine on desktop spreadsheet program... Please Help!
------------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment