ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Time sheet manipulation (https://www.excelbanter.com/excel-discussion-misc-queries/118276-time-sheet-manipulation.html)

souchie40

Time sheet manipulation
 
Can some plaese tell me how I can get a negative time to show?

What I mean is this coloumn A as total worked time and coloumn B as weeks
hours, so what i want is the sitiation where if coloumn A is smaller than B I
get a negative time so that the rolling toil time is maintained ie week 1 I
generate 8 hours toil week 2 I generate -2 hours toil so toatl is 6. The
cells are formatted as time in the fashion of 37:30:55.

MTIA


All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com