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.