View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Help with time interval

Google Groups sometimes adds "formatting junk" to posts.

I'm using Outlook Express and I can see the first "-" in: "hh:mm-"

I think that's intended to be the time separator:

time-time

The other one you're seeing was put there by Google: +"3:00-"

I don't see that other "-" using Outlook Express.

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
I think there's something going in in posting, The way I "see" your
formula it has additional minus signs you obviously didn't type
yourself. The first is after the first "hh:mm" format which i see as
"hh:mm-" and the second is after +"3:00" which I see as +"3:00-" and
while we both know they shouldn't be there the OP might not. Once
again, nice formula.

Mike

On Dec 28, 10:07 am, barry houdini <barry.houdini.
wrote:
Mike H;160218 Wrote:

Neat if you get rid of the couple of - signs that seem to have crept in


Hello Mike, there seems to be an asterisk after the last 0:30 in the
version you quoted. That isn't in the original formula I posted,
otherwise the formula is OK, I think, and as I intended.

--
barry houdini
------------------------------------------------------------------------
barry houdini's
Profile:http://www.thecodecage.com/forumz/member.php?userid=72
View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=44469