Now we know how to subtract time, but what if we want to subtract the lunch time from a Timesheet? This video shows you one way to achieve this.
Sometimes, when you download data from systems, like SAP, Dates actually come in as Text – which means they are non-calculable. However, if Excel recognises their structure, then it can convert them into Dates that can be calculated, using the DATEVALUE function.
You know the date that a project is going to start. You know how many days you have to complete it. What you don’t know is the date that it’s going to end, because you need to exclude Saturdays and Sundays – and Holidays. Well, that’s what this function does.
Dates are easy to calculate with because they are actually numbers. However, sometimes you’ll come across some formatting issues. This video will show you one way to deal with this.