Forum Discussion

Pmorg73's avatar
Pmorg73
Post Patron
7 years ago
Solved

Convert hour format data to decimal

Hi   I have seen advice on going the other way. But I have a large data set that exports the data in hours (Example below). I intend to sum this time so need to convert to decimal. In Excel this is...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Pmorg73 

     

    I see that the format for time taken as a long date and hence the formula gives different value.

     

    Going through your file, assuming the time is shown in longdate format then I tweeked the formula

     

    Time*24 = 'Table1'[[Time]] Time]*24 - 24
     
    By doing so I got the result the same as Time*24 done in excel and ported
    over.
     
     
    Cheers
     
    CheenuSing
Pmorg73's avatar
Pmorg73
Post Patron
7 years ago

Does seem to work. Thanks for that. So I understand it what does the -24 do? 

 

Time*24 = 'Table1'[[Time]] Time]*24 - 24

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Pmorg73 ,

 

I was checking the values without '-24' . Everything was more by 24.  So I decided to substract 24 and check. It worked.

 

Cheers

 

CheenuSing