Modeling time in excel is quite advanced. The list of features includes
- time
- day
- hour
- minute
- second
- now
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!
Learn financial modeling techniques with us. Our financial modeling tutors are MBAs or CPAs and can help you understand the process of laying out your financial model step by step and help you learn how to build a financial model from scratch. If you are writing a business plan or an idea you are evaluating, understand the financial implications by building an spreadsheet model.