View Single Post
  #1   Report Post  
Aashish
 
Posts: n/a
Default 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