Time sheets

Posted by Sharyn on November 02, 2001 1:38 PM

I want to create a time sheet but I don't know how to add the hours up. eg 12:00 22:00 I know it equals 10 but how do I get it to do it automaticaly.
I would appreciate any help I am using excel 97.
Thank you

Posted by IML on November 02, 2001 2:03 PM

Assuming 12:00 in A1 and 22:00 in B1
then =b1-a1 will equal 10:00
or
=(B1-A1)*24 will equal 10. You may have to change format to general to show this properly.

Posted by Ken on November 02, 2001 2:05 PM

Hi Sharyn,

If cell A1 has 12:00 cell B1 has 22:00 then in cell C1 the formula would be =B1-A1

Thanks
Ken

Posted by EDDIE G on November 02, 2001 2:14 PM

provide your email address and i will send you a nice timesheet that will show you how to calc. the formulas.

Posted by Sharyn on November 02, 2001 2:35 PM

I tried that and I get #value
thanks Sharyn...

Posted by Sharyn on November 02, 2001 2:37 PM

My email address is
shazza1962@hotmail.com
Thank you Sharyn...

Posted by Sharyn on November 02, 2001 2:40 PM

Hi Sharyn, If cell A1 has 12:00 cell B1 has 22:00 then in cell C1 the formula would be =B1-A1 Thanks

Thank you Ken, I did try that and I get # value
Thanks Sharyn...

Posted by Sharyn on November 02, 2001 5:19 PM

I would really appreciate your help Sharyn...

Posted by IML on November 05, 2001 6:20 AM

Hopefully you got your answer. If not, it sounds like this could be a formatting issue (ie you really don't have time)
You may want to see if you get a true result with =isnumber(A1) and =isnumber(B1). They both should be true.
Alternatively, you could play around with
=TIMEVALUE(B1)-TIMEVALUE(A1)
and
=(TIMEVALUE(B1)-TIMEVALUE(A1))*24
but usually the operator will coerce text entrys to number when possible.

Good luck

Posted by Sharyn on November 07, 2001 1:51 AM

Thank you for your help EDDIE G sent me a time sheet already formatted which has helped imensely
Thanks again for your help..
Sharyn......