I am doing a timesheet that shows a start time and and end time. I know how
to make the result show up as a decimal, but I would like to be able to not
have to put 24 hour time in the end time column. Is this possible.

Select Colum
Format Cells|Time
Select 1:30 PM

If this helps click Yes
--------------
Jacob Skaria

"amber s" wrote:

I am doing a timesheet that shows a start time and and end time. I know how
to make the result show up as a decimal, but I would like to be able to not
have to put 24 hour time in the end time column. Is this possible.

Hi,
I don't understand your sentence "but I would like to be able to not
have to put 24 hour time in the end time column."
What do you mean?

amber s;275138 Wrote:
I am doing a timesheet that shows a start time and and end time. I know
how
to make the result show up as a decimal, but I would like to be able to
not
have to put 24 hour time in the end time column. Is this possible.


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=76743