Time Counting Formula

  • Thread starter Thread starter Cody Thimm
  • Start date Start date
C

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!!!???
 
Hi
simply use
=B1-A1
and format this cell as time

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