Wednesday, February 18, 2015

yogi_ Convert Row by Row Time Given In Column D In Text (Minutes and Seconds) Into Time In Numeric (hh colon mm colon ss)

             Google Spreadsheet   Post  #1897
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-18-2015
post by  Ashlee Wall:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/u9yk-9krGoU
How to format a cell from 1 minute 30 seconds to 1:30
Please help!!! I am just starting to use Google sheets with a new job. They want me to transfer data from old sheet to new sheet. The old sheet is using 1 minute 30 seconds and they want new sheet to be formatted to say 1:30 instead. Thanks in advance for your help!!
----------------------------------------------------------------------------------------------------------------------------------------