Working with time-of-day in PowerPivot and PowerView


  • Hi All -

    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?


    Peter Wood

    Thursday, February 27, 2014 2:10 PM

All replies