I have a table called Time Periods, which contains the following columns: ID, StartTime, EndTime. StartTime and EndTime are in the format dd.mm.yyyy hh:mm.
I would like to calculate the time used for each day. The time periods are several days long. The result should be a new table called UsedTime, which has one value for each day, which is the time used for that day.
-M
I would like to calculate the time used for each day. The time periods are several days long. The result should be a new table called UsedTime, which has one value for each day, which is the time used for that day.
-M