Actually, do this extra step - multiply by 24 (hours per day). The resulting
formula should look like

=(E14-D14)*24

where E14 is the end time, D14 is the start 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! :)