Hello! So I was looking through the forum and found some formula that are kind of similar to what I looking for but with one exception:
I will like to convert [h]:mm:ss to d:hh:mm:ss ; where each 7.5 hours = 1 day.Ex. 7hr 30min 00sec = 1day 0hr 0mm 0s8hr 30min 00sec = 1day 1hr 0min 0sec9hr 45min 00sec = 1day 2hr 15min 0sec
I don't know if there is a formula for this, but if anyone can create one, I will be very grateful!!!
Thanks!!
Bookmarks