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
...
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"
wrote:

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