Convert Date Format to Minutes
 

I have a spreadsheet from an outside source and the Minutes are formatted as
a date, so in the formula bar it looks like this: 1/3/1900 10:00:00 PM but
in the actual cell, it looks like this: 94:00:00. How can I get the cell to
read just 94? Thanks!!

Convert Date Format to Minutes
 

If you want to see just the 94, format as [h]. Otherwise =A2*24 and format
as Number or General, not Time.
Remember that this is hours, not minutes.

Formatting as [m] will show 5640, as will =A2*24*60 if you format as Number
or General, not Time.
--
David Biddulph

"D" wrote in message
...
I have a spreadsheet from an outside source and the Minutes are formatted
as
a date, so in the formula bar it looks like this: 1/3/1900 10:00:00 PM
but
in the actual cell, it looks like this: 94:00:00. How can I get the cell
to
read just 94? Thanks!!

Convert Date Format to Minutes
 

I'm not sure I completely follow what is going on with this value (94:00:00
is 94 hours, not minutes); but, if you want to display it as 94, you can
Custom Format the cell using "[h]" (without the quote marks).

Rick


"D" wrote in message
...
I have a spreadsheet from an outside source and the Minutes are formatted
as
a date, so in the formula bar it looks like this: 1/3/1900 10:00:00 PM
but
in the actual cell, it looks like this: 94:00:00. How can I get the cell
to
read just 94? Thanks!!

Convert Date Format to Minutes
 

Sorry, for me it means minutes but really, needs to be a hard # of 94. Your
process works with the custom formatting, then adding a helper column and
multiplying by 24. Would there be any other way of converting? I have users
who will need to be doing this to approximately 20 reports, and 20 columns a
month? Seems a bit tedious. Any thoughts?

"Rick Rothstein (MVP - VB)" wrote:

I'm not sure I completely follow what is going on with this value (94:00:00
is 94 hours, not minutes); but, if you want to display it as 94, you can
Custom Format the cell using "[h]" (without the quote marks).

Rick


"D" wrote in message
...
I have a spreadsheet from an outside source and the Minutes are formatted
as
a date, so in the formula bar it looks like this: 1/3/1900 10:00:00 PM
but
in the actual cell, it looks like this: 94:00:00. How can I get the cell
to
read just 94? Thanks!!