Posted to microsoft.public.excel.misc

Paul

external usenet poster

Posts: 661

decimal time conversions

Hi

I have decimal numbers that need to be converted to times eg 18.76 = 18 mins
46 seconds using the text formaula but I have 26.35 that equals 2.21. Why can
anyone help?

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
Changing decimal time into 24 hour time and reverse	Bobzter100	Excel Discussion (Misc queries)	4	January 25th 08 11:38 AM
Time conversions	Holsapple	Excel Worksheet Functions	3	September 18th 06 09:06 PM
Converting decimal time to standard time?	mpendleton	Excel Discussion (Misc queries)	4	May 12th 06 10:07 PM
Decimal time	Kim	Excel Worksheet Functions	12	September 20th 05 04:22 AM
Time calculations & text conversions	Kenny Hubbard	Excel Discussion (Misc queries)	1	February 5th 05 10:15 PM

All times are GMT +1. The time now is 10:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us