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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Seth J" wrote:

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

Im 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