Making a timesheet excel file:
Column A is start time, Column B is end time, Column C is the difference in times. My problem is taking standard hour values (10:00 AM, 9:30 PM for example) and subtracting them from other hour values to get a non-hour value.
For example, Col. A = 9:30, Col. B = 11:00
How do I get Col. C to output 1.5 as the value? Will there be issues when going from AM to PM?
Thank you!
Bookmarks