Time formula 0600 = 11:00AM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count occurences of time 1
Sumproduct with date and time? 1
How do I calculate the difference between 11:00pm and 7:00am 3
Formula for 20 minute meetings 4
calculate time does not calculate 2
Ranges of time logic? 2
Formula 3
cannot type in cells, time format 12:00am 1

Back
Top