Hours Column + Minutes Column.. how to combine?

[AaronRogers3]

Hi All,

I have an hours column and a minutes column which are simply just whole numbers.

I would like to combine these columns so that the minutes updates to an hour after 60.

How could i do this, i have tried formatting however i have been having no luck.

[Anonymous]

@AaronRogers3,

This link should help: https://www.youtube.com/watch?v=D-Z1k5o0upo&feature=youtu.be

[AaronRogers3]

That looks good... but my hours field and my minutes field are just whole numbers not date/time.

For example:

Hours : 4

Minutes : 45

[v-xjiin-msft · Accepted solution]

Hi @AaronRogers3,

To achieve your requirement, you can create a calculated column with Time() function. Then change this column to Time type.

Please refer to following sample:

Hour&Minutes = TIME(TableTime[Hour],TableTime[Minutes],0)

Thanks,
Xi Jin.