...30 minutes).  When I put your formula in the next cell, it calculated 0:33 (which would read as 33 minutes ...posts on timesheets and cannot find what I need.. If you can help, please do. Cell G totals daily time... (over 8 full hours) I want displayed in cell I --- also rounded DOWN to the nearest quarter hour.  Ex...

...30 minutes). When I put your formula in the next cell, it calculated 0:33 (which would read as 33 minutes ... on timesheets and cannot find what I need.. If you can help, please do. Cell G totals daily time... to display only the hours up to and including "08:00" --- rounded DOWN to the nearest quarter hour. Any...

... 30 minutes).  When I put your formula in the next cell, it calculated 0:33 (which would read as 33 minutes rather...posts on timesheets and cannot find what I need.. If you can help, please do. Cell G totals daily time ...H to display only the hours up to and including "08:00" --- rounded DOWN to the nearest quarter hour. Any ...

... 30 minutes). When I put your formula in the next cell, it calculated 0:33 (which would read as 33 minutes rather ... posts on timesheets and cannot find what I need.. If you can help, please do. Cell G totals daily time logged ... H to display only the hours up to and including "08:00" --- rounded DOWN to the nearest quarter hour. Any ...

... 30 minutes). When I put your formula in the next cell, it calculated 0:33 (which would read as 33 minutes rather... posts on timesheets and cannot find what I need. If you can help, please do. Cell G totals daily time logged...H to display only the hours up to and including "08:00" --- rounded DOWN to the nearest quarter hour. Any ...

...hours 30 minutes).  When I put your formula in the next cell, it calculated 0:33 (which would read as 33 minutes rather ...numerous posts on timesheets and cannot find what I need. If you can help, please do. Cell G totals daily time logged ...cell H to display only the hours up to and including "08:00" --- rounded DOWN to the nearest quarter hour. Any ...

... hours 30 minutes). When I put your formula in the next cell, it calculated 0:33 (which would read as 33 minutes rather than... numerous posts on timesheets and cannot find what I need. If you can help, please do. Cell G totals daily time logged in...cell H to display only the hours up to and including "08:00" --- rounded DOWN to the nearest quarter hour. Any ...

... news:8262EC4F-EFA8-4AC3-9FC3-E6CA3D195BE0@microsoft.com... I'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 ...

...'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...

... From: "Bee" <Bee@discussions.microsoft.com> Subject: Timesheet Calculation with Time Rounded Date: February-29-08 6:33 PM "Ron de Bruin" <... one doesn't know the exact subject line? -- Thank you for your time and effort in replying to my questions. Bonnie ---------------- This post is a suggestion for ...