Instead of the way you are doing it, remember that Excel stores dates and
times as numbers. Dates as an integer (the number of dates since Jan 1st
1900?), and times as a fraction (8AM = .3333...)

Simply subtract the start time from the end time. Also subtract any time
off for lunch and breaks that should not be counted.

The result might look funny as Excel might format the resulting cell as a
date. Format THAT cell as a number and you'll have your elapsed time.





"Dugster" wrote:

Hi, I hope you don't mind a newbie asking newbie questions? :) I'm a filling
short of a sandwich when it comes to excel, so please keep that in mind if
you decide to be so kind as to respond. Thanks!

I am trying to get the total hours and minutes worked over two periods to
show in columns I and J. Honest, I've used the help file and looked about
here but I just don't get it. :s I'd appreciate all and any help. Thanks.

A B C D E F G H I J
1 AM AM PM PM Deficit B/F
2 Start Finish Start Finish
3 Hrs Mins Hrs | Mins
4 09 | 10 12 | 30 13 | 00 17 | 00
5 08 | 30 12 | 30 13 | 00 17 | 30
6 09 | 00 12 | 00 12 | 40 17 | 00



--
I don't mind being wrong, I'd just like you to prove it! :)