Cartillo
asked on
Sum total duration
Hi Experts,
I would like to request Experts help. Is that any possibilities to build MSSQL formula for total duration at column “Total_Duration” based on data at column TimeIN(time) and TimeOUT(time). Intent to add this formula at “Computed Column Specification” at ( formula) row. Hope Experts will help to create this formula.
I would like to request Experts help. Is that any possibilities to build MSSQL formula for total duration at column “Total_Duration” based on data at column TimeIN(time) and TimeOUT(time). Intent to add this formula at “Computed Column Specification” at ( formula) row. Hope Experts will help to create this formula.
sorry
TimeOUT-TimeIN
(datediff(MINUTE,[TimeOUT],[TimeIN]))
(datediff(HOUR,[TimeOUT],[TimeIN]))
(datediff(SECOND,[TimeOUT],[TimeIN]))
you can use either of the above 3 methods to get time difference in minutes,HOURS or SECONDS respectively.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thanks for the help
Thanks for the help
Open in new window