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.