I've got a sheet that has, Time Out (cell A), Time In (cell B), Total Time (cell C), Amount Earned (cell D). I also have a column that is supposed to computer the hourly rate in cell E.
Cell A and Cell B are set to: Format = Time
Cell C is set to: Format = Time --> Custom --> h:mm
Cell D is set to: Accounting
Cell E is set to: General
I subtract B from A to fill C; I divide D by C to fill E. But, E isn't computing properly and I assume it's because of the h:mm format in Cell C.
Any ideas on what I can do to fix this?
Thanks,
Chip
Bookmarks