Calculating time difference

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
 
M

Max

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"
 
M

Max

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
 
Top