Multiply static time by variable number in minute / seconds
Posted on 2012-04-10
I always get confused on getting the correct time it requires to perform a task based on a set number and keep in minute/second format.
I need the outcome to be in the minute:second format 0:00:00
A1 is the time to perform the task (in this case 0:01:04)
A2 is the variable number to enter for the count of tasks to be completed (scenerio is 24)
(A2 will be keyed by end-user and is a variable number)
In my example 24 x 0:01:04 = 0:25:36
I am not sure if this is an excel expression or a vba change cell calcuation to derive this result.
Any assistance would be appreciated since I am stuck and need to use this format for numerous task activities.