XL stores dates as integral offsets from a base date, and times as
fractional days, so you can do simple math (multiplying by 24 to convert
days and fractional days to hours):


A1: 9/2/2005
B1: =(A1-Date(2005,1,1))*24

An entry of 4:30 will be interpreted as 4 hours, 30 minutes, and
converted and stored as 0.1875 (regardless of how it's displayed).


In article <emvmG3yVFHA.4056@TK2MSFTNGP15.phx.gbl>,
"Everett Joline" <ejoline@optonline.net> wrote:

> If I have a column of values with a format like 9/2/2005 4:30, how
> do I convert that to decimal hours after (say) 1/1/2005 0:0?
> Also, is 4:30 routinely treated as HH:MM or might it be interpreted as
> MM:SS?