I have created a Timesheet spreadsheet, in Excel, that calulates the amount of time between to manually entered times.
This is the formula I am using =IF((OR(D8="";B8=""));0;IF((D8<B8);((D8-B8)*24)+24;(D8-B8)*24)) The formula works very well and does return the corrent amount of elapsed time and the result is not rounded.
But, when try to multiply it by 15.00 I always receive a rounded amount. For example, when the time is 2.67 and I multiply that by 15.00 I get 40.00 but it should be 40.05.
I have checked the formatting and that isn't the problem. I don't see anything in this formula that would tell it to round and the formula I am using to multiply it by 15.00 is this =SUM(F9*15) (F9 is the location of the time calculation result).
Does anyone know why it would be doing this? :confused:

Thank you.

Quote:

---

Originally Posted by bbianco

I have created a Timesheet spreadsheet, in Excel, that calulates the amount of time between to manually entered times.
This is the formula I am using =IF((OR(D8="";B8=""));0;IF((D8<B8);((D8-B8)*24)+24;(D8-B8)*24)) The formula works very well and does return the corrent amount of elapsed time and the result is not rounded.
But, when try to multiply it by 15.00 I always recieve a rounded amount. For example, when the time is 2.67 and I multiply that by 15.00 I get 40.00 but it should be 40.05.
I have checked the formatting and that isn't the problem. I don't see anything in this formula that would tell it to round and the formula I am using to multiply it by 15.00 is this =SUM(F9*15) (F9 is the location of the time calculation result).
Does anyone know why it would be doing this? :confused:

Thank you.

---

Thanks anyway. I already figured out the answer. :)