Yes i know that but if its a minus figure at the end of a week how do i get
it to automatically go into a debit column or if im over go into a credit
column?
"Paul Sheppard" wrote:
Matt Wrote:
Hi all
Ive got a timesheet woking now for my company but they are wanting me
to add
2 more colums for flexi one for how much im in credit with
flexi/overtime
over 37.5 hours and another colum saying if im in debit/ under hours
worked
how can i get this to automatically put overtime or undertime straight
into
the correct column.
Thanks
Hi Matt
Total Hours worked - 37.5 will give flexi/over as a plus and
flexi/under as a minus
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467806