minute formula

T

tryingtolearn

newbie to excel and formulas
I need to create a doc that will calculate how long it takes an employee to
complete a task

column A will have begin time and column B end time ... I need to know in
minutes the difference between the two
 
R

Ron Rosenfeld

newbie to excel and formulas
I need to create a doc that will calculate how long it takes an employee to
complete a task

column A will have begin time and column B end time ... I need to know in
minutes the difference between the two
Click to expand...

=EndTime - BeginTime

either format as [m]

or multiply by 1440

e.g.
=(endtime-starttime) * 1440


--ron
 
Top