A
Andy.Fairley
I have a flexi time worksheet it works fine when i am in credit but if im in
negative time the hours and mins just show as hashes
the calcullation is a simple time in time out subtreacted from the hours for
a standard working day
example
start time 9:00 finish 17:00 = 8hrs
normal working day is 7:10
this gives me 50 mins credit this would show on my total colum
but if i only worked 6 hrs then i would be 1hr 10 in debit this would show
as hashes in the total colum is there away of showing the negative hours
excel 2007
any help would be appreciated
thanks
negative time the hours and mins just show as hashes
the calcullation is a simple time in time out subtreacted from the hours for
a standard working day
example
start time 9:00 finish 17:00 = 8hrs
normal working day is 7:10
this gives me 50 mins credit this would show on my total colum
but if i only worked 6 hrs then i would be 1hr 10 in debit this would show
as hashes in the total colum is there away of showing the negative hours
excel 2007
any help would be appreciated
thanks