Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calculation Help

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?