Problem with formatting time

I have a timesheet that I've created in Excel (2k). In one location I display
the time formatted as Custom, [h]:mm. In another location, I need to take that
value and display it as a regular number. Example:

1st location: 16:00 hours (two work days) (totals of range of rows)
2nd location: 16.00 (reference to 1st location)

Currently I have plug the 2nd location in manually, because I can't figure out
how to convert the time "16:00" to "16.0". If I just change the formatting used
in the 2nd location, my "16:00" becomes "0.67".

Can anyone help? Thanks in advance,

Tom

Time is stored as a fraction of one day, so just multiply by 24.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tcs" <TSmithATEastPointCityDOTorg@> wrote in message
news:57ekm193i165bfqpavae18jq6216850v5l@4ax.com...
> I have a timesheet that I've created in Excel (2k). In one location I
display
> the time formatted as Custom, [h]:mm. In another location, I need to take
that
> value and display it as a regular number. Example:
>
> 1st location: 16:00 hours (two work days) (totals of range of rows)
> 2nd location: 16.00 (reference to 1st location)
>
> Currently I have plug the 2nd location in manually, because I can't figure
out
> how to convert the time "16:00" to "16.0". If I just change the
formatting used
> in the 2nd location, my "16:00" becomes "0.67".
>
> Can anyone help? Thanks in advance,
>
> Tom

Excellent! Thanks so much.

On Thu, 3 Nov 2005 16:49:49 -0000, "Bob Phillips"
<bob.phillips@notheretiscali.co.uk> wrote:

>Time is stored as a fraction of one day, so just multiply by 24.