'i would like a date in a celll in excel to be 8 hours (working) and not 24
I need some help with a formula in excel. I want to have a cell for a start date and time for a project and a cell for a end date and time. I can do this but I would then like to know how long this project took in working hours. So if a project took 9 hours I want it to display as 1 day and 1 hour
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
