i am creating a time sheet to track hours worked in a week and the pay due
for those hours worked. each day has 4 cells to enter in-out-in-out times.
the times are entered as, i.e. "8:30 am" and formatted as Time. i use the
equation, =((firstoutcell-firstincell)+(secondoutcell-secondincell))*24 to
correctly get a daily total in hours (formatted as Number to two decimal
places). i then use the SUM function to correctly total up the 5 days hours
(as Number to two decimals). but when i multiply the cell containing the
weekly hours total times the hourly wage, instead of getting the exact dollar
amount, i get a rounded up amount. i am using the correct amount of decimal
places in the answer and the cell is big enough. any answers out there?