Calculating time difference
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
|