Forum Discussion
cottrera
Post Prodigy
Post ProdigyConvert time (hh:mm) to decimal
Hi I have the following table Time Received Time Decimal 09:51 9.85 09:40 9.67 09:44 9.73 18:37 18.62 16:04 16.07 16:28 16.47 01:30 1.50 08:32 8.53 09:34 ...
nonono, you don't want to add column to column. In addition to that your [Time Received] is not text but of "time" type. That's smth new to me. Replace your "lady in red" with this:
#"Added Custom" = Table.AddColumn(#"Inserted Hour", "Time Decimal", each [a = Time.ToRecord([Time Received]), b = Number.Round(a[Hour] + a[Minute] / 60, 2)][b])
cottreraPost Prodigy
Post ProdigyThats got it thank you for your patience , legend 😀