#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sajid
 
Posts: n/a
Default fx duration

fx function of DURATION in ms excel.
Example given in microsoft help does not work if we paste it on worksheet.
error reported. #NAME? & what this 5.99 result tells

If anyone knows please tell me on



thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default fx duration

First paragraph of HELP for DURATION:

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.


--
Kind regards,

Niek Otten

"sajid" wrote in message ...
| fx function of DURATION in ms excel.
| Example given in microsoft help does not work if we paste it on worksheet.
| error reported. #NAME? & what this 5.99 result tells
|
| If anyone knows please tell me on
|
|
|
| thanks


Reply
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
Dividing a time span into shifts - overlapping days Heidi Excel Worksheet Functions 17 February 28th 06 01:40 AM
Format cell to show duration of phone calls Dana Excel Worksheet Functions 1 February 10th 06 03:09 PM
Duration citizens1stbank Excel Discussion (Misc queries) 0 July 15th 05 06:23 PM
convert duration (hr:mn:sec) in to equivalent sec pg Excel Discussion (Misc queries) 2 April 26th 05 07:54 AM
How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o. Louis Excel Worksheet Functions 1 November 22nd 04 01:36 PM


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

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

About Us

"It's about Microsoft Excel"