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

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

That's OK until the days go beyond 31.
--
David Biddulph


Luke M wrote:
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.

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