Michelle,

try this:

=E9-C9-1/24+(C9E9)

as these are times, which are stored as fractions of a 24-hour day, you
need to subtract 1/24th for an hour. Your other formula would now
become:

=F9*24

Hope this helps.

Pete

mochamichelle wrote:
I have gotten some great tips from this forum and have been to the site
http://www.mvps.org/dmcritchie/excel/datetime.htm which was very helpful.
But - can someone give me the quick and painless way to calculate the
difference in time less one hour (lunch).
I am currently using =E9-C9+(C9E9) and formatted it to [h]:mm:ss , then
having a cell next door to it to calculate it into decimal hours (F9*24-1)
really...
but how do I get that (-1 hour) into the cell that calculates the
hours/minutes? I have tried tagging a -1:00 on the end or just a -1 but I
get the ole #VALUE error.

Thanks in advance - I know this is likely easy...

Michelle