ExcelBanter - Time formula 0600 = 11:00AM

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time formula 0600 = 11:00AM (https://www.excelbanter.com/excel-discussion-misc-queries/19073-time-formula-0600-%3D-11-00am.html)

Aashish

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

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

All times are GMT +1. The time now is 07:52 AM.