Wednesday, July 17, 2013

yogi_Convert A Column Of Hours Minutes Seconds Row By Row To Days Hours Minutes

                                          Google Spreadsheet   Post  #1288
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 17, 2013
user L1napier (http://productforums.google.com/forum/?zx=d54y1jyirg5q#!category-topic/docs/spreadsheets/lllasywpUf4)
Within the same cell that has number format hh:mm:ss, is there any way to convert it to dd:hh:mm?  


A1--------------------
48:22:00   <I need to auto convert to 02:00:22 (dd:hh:mm)
-------------------------------------------------------------------------------------------------------------------------------------------
I have not tried it doing it in the same cell ... following is a formula based solution