View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Walter Briscoe Walter Briscoe is offline
external usenet poster
 
Posts: 279
Default time_report_date-wise_employee-wise

In message of Mon, 10 Mar 2014 07:39:23
in microsoft.public.excel.worksheet.functions, Claus Busch
writes
Hi,

Am Sun, 9 Mar 2014 19:38:34 -0700 (PDT) schrieb via135:

I am getting value 0 in all the cells.!


check the format of your times
Have a look:
https://onedrive.live.com/?cid=9378A...B6121822A3%213
26#cid=9378AAB6121822A3&id=9378AAB6121822A3%213 26
for workbook "Time_Report"


Claus,
I did so. I am surprised columns 1 and 2 of sheet 2 are literals, rather
than formulae. I also got 0 on column 3 - I guess because I had not set
1 & 2.
--
Walter Briscoe