calculating hours?

[Tal]

I'm normally able to work stuff out with excel when I need to but this one
has me stumped.....maybe i'm overlooking the obvious

A community group i volunteer with has been keeping a record book of hours
volunteers have spent at the office. I figured it'd be handy to have this
converted to a digital format and to calculate how many hours each volunteer
has clocked up.

What i would like to do is simple enough but I can't figure out the formula
to do it!

we have the date the person worked, the time they logged in and the time
they logged out. I want to be able to calculate how long each person worked
each day they came to the office. eg.

Date Time in Time Out Total time


I've tried the Hour function, but that only calculates in total hours and
ignores the minutes and you have to be sure to add the date to the time in
and time out columns as well as the acutal time, which means adding the date
three times for every entry.

Would appreciate any help! thanks.

 

[Frank Kabel]

Hi Tal

i assume that both time columns are formated as time and an example
entry could be
Time In Time Out
08:00 16:00
and your exspected result would be 08:00

Just subtract both cells (e.g. B1-A1)
Frank

 

[Niek Otten]

To learn all about calculating with times and dates, visit:

http://www.cpearson.com/excel/datetime.htm#AddingDates

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Naraine]

Assuming your data is in a1 to d2
Date Time In Time Out Total Time
5/1/2004 7:00 AM 5:30 PM


in b3 type =SUM(HOUR(B2)*60,MINUTE(B2),SECOND(B2)/60)

in c3 type =SUM(HOUR(C2)*60,MINUTE(C2),SECOND(C2)/60)

in d3 type =(C3-B3)/60

 

[Tal]

that was the first thing i tried but it didn't work - of course, i try it
again and it works perfectly LOL.......argh! gotta hate that

No idea what I could have done wrong the first time, i tried it several
times. But then it could be my misbehaving computer, it does strange things
sometimes (and no, i dont 'have a virus )

Thanks