Calculating Time
 

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.


"Peo Sjoblom" wrote:

assuming you are using real time formats in start and end cells and integer
minutes in lunch cell, e.g.

08:00 17:30 (or 05:30 PM) 45

would give

=End-Start-Lunch/1440

formatted as time

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


"BruDe" wrote in message
...
I've been trying to figure out how I can calculate the differenc between
two times. The project I'm working on tracks attendance patterns using
Excel. So, what I want it to do is take a start time, end time, then
subtract a lunch period (from 30 - 60 minutes) and display the total number
of hours worked.

Calculating Time
 

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

http://nwexcelsolutions.com


"Hanr3" wrote in message
...
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.


"Peo Sjoblom" wrote:

assuming you are using real time formats in start and end cells and
integer
minutes in lunch cell, e.g.

08:00 17:30 (or 05:30 PM) 45

would give

=End-Start-Lunch/1440

formatted as time

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


"BruDe" wrote in message
...
I've been trying to figure out how I can calculate the differenc
between
two times. The project I'm working on tracks attendance patterns using
Excel. So, what I want it to do is take a start time, end time, then
subtract a lunch period (from 30 - 60 minutes) and display the total
number
of hours worked.

Calculating Time
 

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.


"Peo Sjoblom" wrote:

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

http://nwexcelsolutions.com


"Hanr3" wrote in message
...
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.


"Peo Sjoblom" wrote:

assuming you are using real time formats in start and end cells and
integer
minutes in lunch cell, e.g.

08:00 17:30 (or 05:30 PM) 45

would give

=End-Start-Lunch/1440

formatted as time

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


"BruDe" wrote in message
...
I've been trying to figure out how I can calculate the differenc
between
two times. The project I'm working on tracks attendance patterns using
Excel. So, what I want it to do is take a start time, end time, then
subtract a lunch period (from 30 - 60 minutes) and display the total
number
of hours worked.