Calculating Time

D

Debbie

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.
 
N

Nick Hodge

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
(e-mail address removed)
www.nickhodge.co.uk
 
J

JE McGimpsey

One way:

A1: 7:30 am
B1: 4:00 pm
C1: =B1-A1

Format C1 as a time.

If the times may span midnight, use

C1: =MOD(B1-A1,1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Work Budget Salary vs Real Time Salary 0
Calculate After hours 3
Adding rota 0
Excel Noob 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0

Top