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.