View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Formula than understands midnight?

Hi Garry,

Am Thu, 24 Apr 2014 16:33:27 -0400 schrieb GS:

This works fine in the 1st section, but doesn't work in the 2nd section


my formula gives me the same results as yours. I started in I3 and
copied down (also over the dotted rows wiht "Copy without formats")
Please look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for the workbook "ProjectsTimeRecord".
My formula is in the column for the comments.
If that is not what you want, can you please explain me in words which
output is expected.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional