Group: microsoft.public.excel.misc · Group Profile · Search for Timesheet Calculation with Time Rounded in microsoft.public.excel.misc
Date: Mar 1, 2008 00:33
...'ve reviewed numerous posts on timesheets and cannot find what I need. If you can help, please do. Cell G totals daily time logged in (in,... I want cell H to display only the hours up to and including "08:00" --- rounded DOWN to the nearest quarter hour. Any excess time (over 8 full hours) I want displayed in cell I --- also rounded DOWN to the nearest quarter hour. Ex: If G displays...