Time Counting Function

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

Cody Thimm

I want to be able to calculate the exact number of
hours between two times during the same day. Is that
possible to do? I've tried =HOUR(B1-A1) but only gives
back rounded hours. I need it to be exact to the quarter
hour for I am using this to calculate hours at my
workplace.

Thank You,
Cody Thimm
 
=B1-A1

formatted as hh:mm

or

=(B1-A1)*24

formatted as general

or

=ROUND((B1-A1)/(1/96),0)*1/96

rounds it to the nearest quarter

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top