I have an employee work schedule all set up in Excel 2016, Windows 10. Cell C3 is “Time In”, C4 is “Time Out”, and D3 is the total number of hours for that day (i.e., I enter In 10:00 AM in C3, and Out 8:00 PM in C4, and D3 automatically gives me 10 hours). Very nice.
However, the D3 cell, total hours for the day, is in Time format, therefore I can't (or can I?) use it as a number for a Sum function at the end of the row – in other words, adding up those cells to get the total hours for the week, Monday hours + Tuesday, ...). Is it possible to have a cell, say D4, which would automatically copy the value in D3, but paste it into D4 as a Number format, so I can take all my row-4 cells, add them up and get total hours for the week. Then, I can very simply plug in the hourly rate, and get my total cost of labor for that week. I'm so impressed that I was able to make this sheet following tutorials, but now I'm stumped.