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?