Forum Discussion

rhaddad87's avatar
rhaddad87
Helper I
4 years ago
Solved

Convert excel formula for time conversion in power query

Hi, community!  I have a query where I need to add a custom column to match what my excel spreadsheet does, the formula is:   IF(MOD(24*MOD(TEXT([#"Land Time (Military Time)"],"00\:00")-TEXT([#"Tak...
  • amitchandak's avatar
    amitchandak
    4 years ago

    rhaddad87 , With help from Duration

     

    Duration.Days([Military Time])*24 + Duration.Hours([Military Time])+ Duration.Minutes([Military Time])/60.0 + Duration.Minutes([Military Time])/3600.0

     

    Change formula as per need

amitchandak's avatar
amitchandak
Super User
4 years ago

rhaddad87 , With help from Duration

 

Duration.Days([Military Time])*24 + Duration.Hours([Military Time])+ Duration.Minutes([Military Time])/60.0 + Duration.Minutes([Military Time])/3600.0

 

Change formula as per need

rhaddad87's avatar
rhaddad87
Helper I
4 years ago

Thank you so much, Amit!  You are truly a rockstar in this community amitchandak