Forum Discussion

walnei's avatar
walnei
Icon for Helper III rankHelper III
9 years ago
Solved

DIFFERENCE BETWEEN DAYS AND HOURS

Hello, can you help me? I have two DATE / TIME columns. Column A - DATE TIME BEGINNING Column B - FINAL TIME DATE example. Column A - 10/12/2017 1:00 p.m. Column B - 10/14/2017 1:30 PM I ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi walnei,

     

    Neither 48h: 30m nor 48:30 is a date/time format. It's a text format actually. You can format it like this:

    HMformat =
VAR minutes =
    DATEDIFF ( [Column1], [Column2], MINUTE )
RETURN
    CONCATENATE ( CONCATENATE ( INT ( minutes / 60 ), ":" ), MOD ( minutes, 60 ) )

     

     

     

     

     

     

    Best Regards!

    Dale

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Datetime is stored as a decimal number where the Whole number portion represents the days since 1899.  The decimal portion referecens the percentage of a day.  I.e. midday is 0.5