This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Challenge completed with just the formula tool.
My solution using formula tool.
Thanks for challenge I have since used these formulas to calculate times between.
I am struggling with my calculation though , can anyone help?
For each completed assessment I have a unique ID, I then have a completed assessment start date and end date, start time and end time with the date time calcs for time taken. In some instances the time taken goes into the next day so the time might start at 10:00pm and end at 05.00am the following day , this is showing as negative (-) hours in the time difference.
In these instances the assessment start date and end date would be different.
Assm ID Assessment Start Assessment End Time Start Time End Hours Minutes
123456 15-09-2016 15-09-2016 23:00 05:30 -17 -30
This should be 6 hours 30.
Also how can I combine my hours and minutes so when I am trying to sum the time taken to complete a assessment it sums both hours and minutes.