LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel 2003 - Help writing a formula to get time (w, d, h, m)

I have been going around in circles trying to write a formula to get weeks,
days, hours, and minutes.

(e38/h37)/2 is the amount of hours.

The format I would like the output to have is:

X week(s), X day(s), X hour(s), X minute(s)

If one doesn't apply, I would like it to NOT be displayed.

This should be easy, but with all of the rounddowns, mods, etc. plus having
all the text added into all of the if statements to get the plurals right, I
am just frozen.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003 robzrob Excel Worksheet Functions 6 July 12th 08 04:51 AM
Scrolling in Excel 07 while writing a formula - Please help!!! Ollie Excel Discussion (Misc queries) 1 April 9th 08 04:03 PM
need help writing a formula in excel Marco New Users to Excel 1 March 26th 08 08:34 PM
Writing formula for excel worksheet Gaurav New Users to Excel 5 February 23rd 07 01:06 PM
Help writing an Excel Formula bella0711 Excel Worksheet Functions 4 September 9th 05 03:57 PM


All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"