==ROUND(A2*96,0)/96

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sawagashi" wrote
in message ...

Hi all

I am currently temping for a agency and the time logging system they
use is a bit dodjy to say the least.

I log in using a e-trac asp system (their clock is fast by 5.43
mins ) and the logging is to the minute but the agency round the
time to the closest 15mins!

Can I get my exel spreadsheet to round time to the closest 15 mins

e.g. 09:00 - 09:07 = 09:00 & 09:08 - 09:15 = 09:15

Help please
as i lost half an hour of pay last week to this dodgy system

Thanks :)


--
sawagashi
------------------------------------------------------------------------
sawagashi's Profile:
http://www.excelforum.com/member.php...o&userid=28883
View this thread: http://www.excelforum.com/showthread...hreadid=486320