Time Formatting Question
"John Calder" wrote in message
...
Hi
Say your time is in cell A1. In the cell next to it (B1) type the formula
[=a1*24*60]. You must first convert the time[1:53:00] to a decimal number,
Then take that number times 60 to convert it to minutes, which is 113
minutes. Or Take the 1:53:00 times 1440 which is 60 times 24. Make sure
you format cell B1 to Gereran or number.
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
|