software

why divide by 1440?
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.quot;Peo Sjoblomquot; wrote:

gt; assuming you are using real time formats in start and end cells and integer
gt; minutes in lunch cell, e.g.
gt;
gt; 08:00 17:30 (or 05:30 PM) 45
gt;
gt; would give
gt;
gt; =End-Start-Lunch/1440
gt;
gt; formatted as time
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; (No private emails please, for everyone's
gt; benefit keep the discussion in the newsgroup/forum)
gt;
gt;
gt; quot;BruDequot; gt; wrote in message
gt; ...
gt; gt; I've been trying to figure out how I can calculate the differenc between
gt; two times. The project I'm working on tracks attendance patterns using
gt; Excel. So, what I want it to do is take a start time, end time, then
gt; subtract a lunch period (from 30 - 60 minutes) and display the total number
gt; of hours worked.
gt;
gt;
gt;

Because the lunch was given as an integer (45) which in excel time equals
45*24 hours thus you need to convert it to excel minutes x/60/24 = x/1440--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Hanr3quot; gt; wrote in message
...
gt; why divide by 1440?
gt; --
gt; Life is an adventure, are you living it?
gt;
gt; These are just my opinions, please feel free to correct them if they are
gt; wrong.
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; assuming you are using real time formats in start and end cells and
gt;gt; integer
gt;gt; minutes in lunch cell, e.g.
gt;gt;
gt;gt; 08:00 17:30 (or 05:30 PM) 45
gt;gt;
gt;gt; would give
gt;gt;
gt;gt; =End-Start-Lunch/1440
gt;gt;
gt;gt; formatted as time
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; (No private emails please, for everyone's
gt;gt; benefit keep the discussion in the newsgroup/forum)
gt;gt;
gt;gt;
gt;gt; quot;BruDequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I've been trying to figure out how I can calculate the differenc
gt;gt; gt; between
gt;gt; two times. The project I'm working on tracks attendance patterns using
gt;gt; Excel. So, what I want it to do is take a start time, end time, then
gt;gt; subtract a lunch period (from 30 - 60 minutes) and display the total
gt;gt; number
gt;gt; of hours worked.
gt;gt;
gt;gt;
gt;gt;
Thanks!
That makes sense.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.quot;Peo Sjoblomquot; wrote:

gt; Because the lunch was given as an integer (45) which in excel time equals
gt; 45*24 hours thus you need to convert it to excel minutes x/60/24 = x/1440
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Hanr3quot; gt; wrote in message
gt; ...
gt; gt; why divide by 1440?
gt; gt; --
gt; gt; Life is an adventure, are you living it?
gt; gt;
gt; gt; These are just my opinions, please feel free to correct them if they are
gt; gt; wrong.
gt; gt;
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; assuming you are using real time formats in start and end cells and
gt; gt;gt; integer
gt; gt;gt; minutes in lunch cell, e.g.
gt; gt;gt;
gt; gt;gt; 08:00 17:30 (or 05:30 PM) 45
gt; gt;gt;
gt; gt;gt; would give
gt; gt;gt;
gt; gt;gt; =End-Start-Lunch/1440
gt; gt;gt;
gt; gt;gt; formatted as time
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; (No private emails please, for everyone's
gt; gt;gt; benefit keep the discussion in the newsgroup/forum)
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;BruDequot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; I've been trying to figure out how I can calculate the differenc
gt; gt;gt; gt; between
gt; gt;gt; two times. The project I'm working on tracks attendance patterns using
gt; gt;gt; Excel. So, what I want it to do is take a start time, end time, then
gt; gt;gt; subtract a lunch period (from 30 - 60 minutes) and display the total
gt; gt;gt; number
gt; gt;gt; of hours worked.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;