Time Counting Function

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
 
P

Peo Sjoblom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
How to work out working hours? 1
Help with a formula for a Time Sheet. 1
problem with time subtraction 7
How to calculate difference between two date & time along with working hours and days 2
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
date/time formula 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0

Top