Time Counting Formula

[Cody Thimm]

I've asked this before but no one answered with a correct
solution. I'm trying to figure out (example: I clock in
at my work place at 3:00 PM and clocked out at 4:45 PM,
how many hours have I been working.) Everytime I try to
add a formula, it always rounds the (1.75) to 2.00 hours.
I need it to be exact. Any Ideas!!!???

 

[Frank Kabel]

Hi
simply use
=B1-A1
and format this cell as time

or use
=(B1-A1)*24
and format as number

 

[cody]

Thank you it worked