Convert a number to Hours, Minutes, etc.

Posted to microsoft.public.excel.misc

external usenet poster

Posts: 47

Convert a number to Hours, Minutes, etc.

Hi,
How do I take a number, e.g., 170.5, and covert it to a weeks, days, hours,
and minutes, based on an 8 hour day and a 40 day week? Simple math just gives
me more decimals. I don't want 4.2625 weeks, I want 4 weeks, 1 day, 2 hours,
30 minutes. I want to be able to do this for any number using a formula or
group of formulas.

All help is greatly appreciated.

Thanks,
Bernie

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
Convert Total Hours and Minutes to Whole Number	BobS9895	Excel Worksheet Functions	3	April 13th 06 07:56 PM
Is it possible to convert a number into hours and minutes	le clef	Excel Worksheet Functions	4	April 1st 06 05:43 PM
How do I convert a number of minutes into hours and minutes?	gyrkin	Excel Worksheet Functions	3	August 18th 05 11:12 PM
Convert a number of minutes like 400 into hours and minutes	bloke	Excel Worksheet Functions	3	June 24th 05 05:00 PM
Convert hours and minutes in time format into fractions of hours..	Akern	Excel Worksheet Functions	4	April 21st 05 02:56 PM

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

Menu

About Us