Time formula 0600 = 11:00AM

Hi all,

I have a column that has time in the format of minutes in the day (i.e.-
0600 = 11:00AM). I tried dividing by 60, and for numbers like 0650 (10:50AM)
I am ending up with 10.83333 and I am stuck there.

How can get it so I can make this calculation? Thanks in advance,

Aashish

Divide the number by 1440 (total number of minutes in the day) and then
format to desired time format (i.e.- hh:mm AM/PM)

"Aashish" wrote:

> Hi all,
>
> I have a column that has time in the format of minutes in the day (i.e.-
> 0600 = 11:00AM). I tried dividing by 60, and for numbers like 0650 (10:50AM)
> I am ending up with 10.83333 and I am stuck there.
>
> How can get it so I can make this calculation? Thanks in advance,
>
> Aashish