Ask Your Question

Calculation Help

asked 2018-09-06 21:23:51 +0100

chippedcracker gravatar image

I made a spreadsheet telling me that I worked for 4:00 if I clocked in at 12:00 PM and clocked out at 4:00 PM. My hourly rate is $11.25. 4:00 formatted into a number gives me 0.17 and therefore if I do a $11.25*4:00 I get a $1.88 when in fact I made $45.00. Is there a way to multiply hourly rate by hours worked without changing the time or currency formatted cells?

edit retag flag offensive close merge delete



The 0.17 seems to be the fraction of a day that you worked (4/24 = 0.166667). So just multiply the 0.17 by 24 then by your hourly rate (0.1666 * 24 * 11.25). The displayed value of 0.17 is rounded off and I expect that when you use the value in the cell you will find it actually has more digits of accuracy than what is displayed.

ve3oat gravatar imageve3oat ( 2018-09-06 21:57:07 +0100 )edit

Thank you.

chippedcracker gravatar imagechippedcracker ( 2018-09-06 22:47:16 +0100 )edit

Using time as a number for calculation can be complicated. I highly recommend reading all the documentation on time formats and time as a number, and then experiment to see what actually happens. It might slow you down at first but will pay off in the end by giving you increased confidence in the accuracy of your results.

ve3oat gravatar imageve3oat ( 2018-09-07 03:59:59 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-09-28 23:43:11 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Multiplying Time per Currency made directly does not work. The correct way to make the hour value become a pure number, is done by multiplying this value by 24. Then the multiplication looks like this: ValueTime x 24 x ValueMode.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-06 21:23:51 +0100

Seen: 87 times

Last updated: Sep 28 '18