Forum Discussion

demonfc's avatar
demonfc
Microsoft Employee
7 years ago
Solved

Time difference HELP

Hello,    I am looking to determine the difference in hours on a given day for a salesman who works that day. The expected result would be essentially be a seperate table with the salesmans name, t...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI demonfc,

     

    In my opinion, I'd like to suggest you extract hour part from datetime column. Then you can create time table with time value from 0:00 to 23:00, build relationship from time table to new 'hour' column.

     

    Column formula:

    Hour = TIME(HOUR([Date]),0,0)

    Calculate table formula:

    Time table = GENERATESERIES(TIME(0,0,0),TIME(23,0,0),TIME(1,0,0))

     

    After these steps, you can use time table column as axis, origin table column as value column create visuals with summarize original table values.

     

    Regards,

    Xiaoxin Sheng

sokg's avatar
sokg
Solution Supplier
7 years ago

Hello demonfc

 

In order to determine the difference in hours you must have a start datetime and a end datetime.

In you date what is your start datetime and what is your end datetime???

  • demonfc's avatar
    demonfc
    Microsoft Employee
    7 years ago

    Hi sokg, 

     

    Basically, it would be a 24 hour date/time of any given day. Starting at 12:00:00 AM of any given day and ending at 11:59:59 PM that same day. 

     

    Thank you for your help.