Problem exporting workbook to HTML

  • Thread starter Thread starter Neil Kennedy
  • Start date Start date
N

Neil Kennedy

Hi all

I work in a call centre, and we are looking at moving towards stats and all
manner of other things to a web based system.

We currently export our agent statistics from servers as csv files, run some
macros and end up with workbook with 32 tabs (one for each day of the month
and one for the monthly totals).

As we have a number of departments and managers, each sheet within the
workbook has the DATA FILTER on, enabling users to select whatever criteria
they want - works fine!

My problem - when I export the file as a web page, I save the whole
workbook, select the interactivity option, to allow all managers to use the
filter as they wish, however - when exported I have discovered that 24 hours
is added to all times - 7:30:00 becomes 31:30:00 etc etc etc

Any idea how to remove this wonderful feature (somehow don't think my boss
will pay for 31 hours for a days work!!!)

Mucho grandee in advance

Cheers and regards
 
Hi Neil,
The following will retain only the fractional part of a number,
=MOD(C2,1) you may have to supply the correct format.

You boss might be happy to pay for negative hours,
but you wouldn't like it.

If subtracting time that goes through midnight:
=D2-C2+(D2<A2)
the logical expression returns either 0 or 1, so it will
add one day if the amount is negative.

More on Date and Time
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/datetime.htm
 
Back
Top