close
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
On Thu, 12 Jan 2006 06:15:02 -0800, quot;tryingtolearnquot;
gt; wrote:
gt;newbie to excel and formulas
gt;I need to create a doc that will calculate how long it takes an employee to
gt;complete a task
gt;
gt;column A will have begin time and column B end time ... I need to know in
gt;minutes the difference between the two
=EndTime - BeginTime
either format as [m]
or multiply by 1440
e.g.
=(endtime-starttime) * 1440--ron
全站熱搜