A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 11 of 11
Search took 0.04 seconds.
Search: Posts made by: Jester
Forum: Links and Linking June 5th, 2010, 03:46 AM Posted to microsoft.public.excel.links
Replies: 4
Views: 7,282
Posted By Jester
Remove Hyperlinks

Thankyou Flo that worked beautifully


John


"FloMM2" wrote in message
...
Jester,
Have you tried to...
Forum: Links and Linking June 4th, 2010, 06:09 AM Posted to microsoft.public.excel.links
Replies: 4
Views: 7,282
Posted By Jester
Remove Hyperlinks

Hi guys, today I had copied some text from the net and pasted it into cells
in Excel 2000. However, when I try and click on the cell, it wants to take
me back to the website I copied the text...
Forum: Calendar December 31st, 2009, 01:49 AM Posted to microsoft.public.outlook.calendaring
Replies: 2
Views: 138
Posted By Jester
Public Holiday Import Outlook 2000

Hi Diane, thanks for the tip. Unfortunately I could not find anything that
would cater for Australian Public holidays be it freeware or paid;
especially a patch that would project at least 4-5...
Forum: General Discussion March 4th, 2007, 11:00 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 56
Posted By Jester
Calculate diiference between 2 dates

Chhers Bill , in my case I am more than happy with what the formula does.
It meets my needs precisely


John
"Bill Ridgeway" wrote in...
Forum: General Discussion March 4th, 2007, 10:47 AM Posted to microsoft.public.excel.misc
Replies: 0
Views: 49
Posted By Jester
Thanks to Mike and Niek Otten

As my mailer cannot currently reply, I needed to say thanks for the info on
the Datedif function. (Thanks also for the speed of the reply) Excel just
never ceases to amaze me. This function is...
Forum: General Discussion March 4th, 2007, 10:28 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 56
Posted By Jester
Calculate diiference between 2 dates

Thankyou very much!!!!
"Niek Otten" wrote in message
...
Hi John,

=DATEDIF(A1,A2,"y") & " Years " & DATEDIF(A1,A2,"ym") & " months...
Forum: General Discussion March 4th, 2007, 10:28 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 56
Posted By Jester
Calculate diiference between 2 dates

Thankyou very much!!!
"Mike" wrote in message
...
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & "...
Forum: General Discussion March 4th, 2007, 09:56 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 56
Posted By Jester
Calculate diiference between 2 dates

I have 2 dates and I want to calculate the difference expressed as the
following string:

(eg) 9 Years 3 months and 13 days

Can anyone help?

Many Thanks

John - Sydney Aust
Forum: General Discussion February 28th, 2007, 09:35 AM Posted to microsoft.public.excel.misc
Replies: 1
Views: 50
Posted By Jester
Date String

I have 2 dates and I want to calculate the difference expressed as the
following string:

(eg) 9 Years 3 months and 13 days

Can anyone help?

Many Thanks

John - Sydney Aust.
Forum: General Discussion September 4th, 2006, 10:59 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 42
Posted By Jester
Calculating differences in time. PLs Help

I have a timesheet and I have a simple formula that calculates the diff
between 2 times and goes something like this:

= (B4-A4)*24

Where B4 = 4:45 PM and A4 = 7:15 AM


The result (formatted...
Forum: General Discussion August 31st, 2006, 12:56 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 46
Posted By Jester
Difference between two times

I have a timesheet and I have a simple formula that calculates the diff
between 2 times and goes something like this:

= (B4-A4)*24

Where B4 = 4:45 PM and A4 = 7:15 AM


The result (formatted...
Showing results 1 to 11 of 11

 
Forum Jump

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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.