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   Jul 17, 2013
user L1napier (!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?  

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