All the references to working with time I have seen are actually working with dates.
I am analysing a number of daily processes. I have log data in PowerPivot which lists for each day, what time-of-day each process completed.
I want to chart the time each process completed (Y-axis) over a time period (dates) (X-Axis) but PowerPivot does not seem to be able to recognize the time as a value, to average the time (say if I summarise at a monthly level).
The only way I have found around this is to convert the time to the an integer containing number of minutes since midnight. This works but the values on the Y-axis (time) are integers - meaningless to most people - rather than HH:mm.
Is there a way to work with time-of-day as a value?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.