If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Time Formatting Question
Hi
I run Excel 2K I download various times from a mainframe. When the come down they look like this: 1:53:00 AM When I try a custom format to convert this to minutes I get the number 1 as a result. I use fortmat:cell:custom:m But, if I enclose the "m" in square brackets ( [m] ) then it converts the time to minutes which is what I want. I would like to know what the [ ] brackets do? Thanks |
Thread Tools | |
Display Modes | |
|
|