Time multiplying

[nemotheman]

So basically I want to take a cell and multiply it by a certain amount of time and then take away one second from it, to get a result.
For example:
A1 x 04:48 - 00:01

Im sure there is a simple answer but I cant seem to find it.

Please help.

[gebobs]

Is that 4 hours and 48 minutes or 4 minutes and 48 seconds. I'll assume the latter, which I will indicate as 0:04:48.

In Excel, the value of each day is 1, each hour is 1/24, each minute is 1/(24*60), and 1 second is 1/(24*60*60). Thus 0:04:48 equals 4/(24*60) + 48/(24*60*60).

Excel will do this for you with the canned function TIME.

Code: Select all

=A1*TIME(0,4,48)-TIME(0,0,1)

[nemotheman]

Thank you very much