Posted to microsoft.public.excel.misc

excel novice

Posts: n/a

How to display 5.5 hours instead of 5.30 when adding \ subtracting

when adding or subtracting times (13:00-08:30) how do i get the answer
formatted to show answer as 4.5 instead of 04:30

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding hours and minutes	Patrick	Excel Worksheet Functions	16	June 18th 08 09:24 PM
Adding hours to a date	Rich	Excel Worksheet Functions	6	November 28th 06 08:50 PM
adding rows of hours and minutes to get a total	Tipps	Excel Worksheet Functions	1	November 4th 05 07:03 PM
Adding hours and minutes	doyouknow2005	Excel Discussion (Misc queries)	2	July 10th 05 10:08 PM
Subtracting paid hours from unpaid hours	ejerry7	Excel Worksheet Functions	5	November 29th 04 04:16 AM

All times are GMT +1. The time now is 03:02 PM.

About Us

"It's about Microsoft Excel"