Leah1668

Junior Member

Posts: 3

Quote:

Originally Posted by Claus Busch

Hi Leah,

Am Sat, 15 Feb 2014 16:41:35 +0000 schrieb Leah1668:

I need to convert 3 cells, one being DAYS, the second Hours, and the
third MINS into a 4th cell which needs to be a decimal. Can anyone tell
me how to do this?

days in A1, hours in B1, minutes in C1 then
=A1+B1/24+C1/1440

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Woohoo, it worked. Thank you sooo much!!

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
complicated excel formula may need an algebra wiz	[email protected]	Excel Discussion (Misc queries)	1	April 18th 13 01:18 PM
complicated excel formula	sweetpeach	Excel Worksheet Functions	8	January 17th 08 04:40 AM
complicated excel formulas	Dan	Excel Worksheet Functions	2	October 16th 07 10:39 AM
Help with a complicated search function in Excel	Ironman273	Excel Worksheet Functions	1	January 9th 06 04:10 AM
complicated function in excel	kelkel	Excel Worksheet Functions	3	April 18th 05 07:19 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us