Modeling time in excel is quite advanced. The list of features includes
You can add or subtract dates, find the number of working days etc. These are however standard commands. It does take some ingenuity to figure out how you can mix and match these to get the output you need when modeling.
How can I figure out the number of weekdays between two days in a year?
Recently, we encountered a challenging modeling issue. Output was in seconds and in the time format. Comparing performances and graphing was difficulty. To work around this we converted all the time into seconds using the hour, minute and second feature and then did the analysis using seconds to measure all data points. This simple solutions worked beautifully!