day:hour:minute:second format

[Seth J]

I want to put data in a day: hour: minute: second format and be able to
multiply it by a number.

I’m doing this in order to create a calculator that will allow me to see if
the memory with a standard memory card last 5 day 1 hour and 51 minutes how
long will it last if the memory is increased by 4

 

[Luke M]

Custom format:
d:hh:mm:ss

This assumes that you are correctly inputting the values in. Remember that
days are stored as integers, and time is stores as a decimal.

 

[David Biddulph]

That's OK until the days go beyond 31.