Hi Experts
I hope you can help :
I am loading data in from an Excel spreadsheet , I wish to be able to calculate the Turnaround time of a Task.
I have the following Columns
hh:mm dd/mm/yyyy hh:mm dd/mm/yyyy
[Start Time] [Start Date] [End Time] [End date]
8:00 1/1/12 10:00 1/1/12
8:00 1/1/12 11:00 1/2/12
8:00 1/1/12 11:30 1/2/12
What I'd like is to have nother column that does the calc - so see below with desired results in Hours:Minutes Format
hh:mm dd/mm/yyyy hh:mm dd/mm/yyyy hh:mm
[Start Time] [Start Date] [End Time] [End date] [turnaround]
8:00 1/1/12 10:00 1/1/12 2:00
8:00 1/1/12 11:00 1/2/12 27:00
8:00 1/1/12 11:30 1/2/12 27:30
Not sure if its best to do as part of the load or if we should calc in a Chart
Can anyone advise how I may do this please ?
Thanks
A
