Converting time

[Sna99]

I am calculating the lenght of time that someting was performed. for example: Time in 12:00 -time out 14:30 the out come is 2:30. How do I make the out come read as 2.5 hours instead of 2:30 or 2.3

Thanks

 

[Eric Lawrence [MSFT]]

Using Excel? Search for "cell formatting" in Help.

--
Thanks,

Eric Lawrence
Program Manager
Assistance and Worldwide Services

This posting is provided "AS IS" with no warranties, and confers no rights.

I am calculating the lenght of time that someting was performed. for

example: Time in 12:00 -time out 14:30 the out come is 2:30. How do I make
the out come read as 2.5 hours instead of 2:30 or 2.30

 

[Beth Melton]

If you are referring to Excel check out
http://www.cpearson.com/excel/datetime.htm for more information on
date and time calculations.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

I am calculating the lenght of time that someting was performed. for

example: Time in 12:00 -time out 14:30 the out come is 2:30. How do I
make the out come read as 2.5 hours instead of 2:30 or 2.30