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.
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
=A1*TIME(0,4,48)-TIME(0,0,1)
Return to General Excel Questions
Users browsing this forum: No registered users and 250 guests