View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H[_3_] Mike H[_3_] is offline
external usenet poster
 
Posts: 39
Default Help with time interval

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