Timesheet - I can't figure out how to do this!

[M.R.S.]

Hi all,

I'd like to create a simple time sheet that calculates the amount of hours
I've worked in a day.

ex:

Date Time IN Time OUT Total Hours

01/01/01 9:00AM 5:00PM 8



And so on for the week, and then have a total at the bottom for total hours
(that part is easy enough).

I've seen this done before.

Better yet, if I could figure out how to enter this data on my Visor PDA and
merge it into excel, that would be excellent.

Any suggestions?!?

Thanks.

 

[RagDyeR]

Start time in A1,
End time in B1,
Enter this formula in a cell formatted as "General" or "Number":
=(B1-A1+(B1<A1))*24*AND(A1<>0,B1<>0)


Both A1 and B1 must have times entered for this to work.

This will also work when the times span across midnight.
--


HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi all,

I'd like to create a simple time sheet that calculates the amount of hours
I've worked in a day.

ex:

Date Time IN Time OUT Total Hours

01/01/01 9:00AM 5:00PM 8



And so on for the week, and then have a total at the bottom for total hours
(that part is easy enough).

I've seen this done before.

Better yet, if I could figure out how to enter this data on my Visor PDA and
merge it into excel, that would be excellent.

Any suggestions?!?

Thanks.

 

[M.R.S.]

Start time in A1,
End time in B1,
Enter this formula in a cell formatted as "General" or "Number":
=(B1-A1+(B1<A1))*24*AND(A1<>0,B1<>0)


Both A1 and B1 must have times entered for this to work.

This will also work when the times span across midnight.
--


HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi all,

I'd like to create a simple time sheet that calculates the amount of hours
I've worked in a day.

ex:

Date Time IN Time OUT Total Hours

01/01/01 9:00AM 5:00PM 8



And so on for the week, and then have a total at the bottom for total
hours
(that part is easy enough).

I've seen this done before.

Better yet, if I could figure out how to enter this data on my Visor PDA
and
merge it into excel, that would be excellent.

Any suggestions?!?

Thanks.

Thank you, that is exactly what I was looking for

 

[JE McGimpsey]

An alternative:

=MOD(B1-A1,1)*24