Thread: minute formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default minute formula

On Thu, 12 Jan 2006 06:15:02 -0800, "tryingtolearn"
wrote:

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


=EndTime - BeginTime

either format as [m]

or multiply by 1440

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


--ron