Time formula 0600 = 11:00AM

A

Aashish

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
 
A

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)
 
Top