Debbie

If the time in is in A1 and B1 has the time out then in C1 enter

=B1-A1

This will return 8:30. Is this OK? (Make sure all cells are formatted to
time)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Debbie" wrote in message
ups.com...
I am trying to calculate the total hours attended when I type in the
hours for the day. For example: 7:30 am is in Time In and 4:00 pm is
in Time Out Column. Now I need to get the total hours, which would be
8.5 hours or 8 1/2 hours. How do I do this? Thank you in advance.