I need a (complicated?) formula

I have created an excel databased from which I have a pivot table to summarize employee time data. This pivot table is based on dates within a two week period of time.  It then rounds the time.  I ta...