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

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.

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!
==============================================

"M.R.S." wrote in message
...
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" wrote in message
...
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!
==============================================

"M.R.S." wrote in message
...
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 :)

An alternative:

=MOD(B1-A1,1)*24

In article ,
"M.R.S." wrote:

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.