Calculating time difference

  • Thread starter Thread starter Robyn Bellanger
  • Start date Start date
R

Robyn Bellanger

I am trying to come up with a formula that will give the result shown as
below:

Time (total hrs worked) is in d2 and shows 8.35 hrs.

Employee should have worked 8.5 hrs. I need a formula that will return the
difference of .15 in minutes short.

Please let me know if you can help!!

Thanks,

Robyn
 
With A1 and B1 containing the numbers 8.35 and 8.5,

Put in say, C1: =(B1-A1)/24
and Format C1 as time ("13:30" format)

C1 will return "0:09"
 
Put in say, C1: =(B1-A1)/24

The above presumes B1 will always be >=A1

Perhaps a more apt formula could be:
=IF(A1<B1,(B1-A1)/24,"")

which'll return blanks: ""
if A1>=B1
 
You must log in or register to reply here.

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

Time punch & hours calculations 1
formula or calculation for adding negative hour and positive hours 1
Calculate time worked 1
Sort list of names 1
time formatting 1
Convert Time to Days 1
Sum of multiple rows, based on date criteria, separate sheets... 0
Need help with a formula 2

Back
Top