| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time formula question... | Excel Discussion (Misc queries) | |||
| Stumper WORKDAYS Problem | Excel Discussion (Misc queries) | |||
| Polynimial trandline formula | Charts and Charting in Excel | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
| Finding last cell to contain same value as current cell? | Excel Worksheet Functions | |||
Linear Mode
