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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()