P
PCERM
I am trying to set up a sheet to display flexi time with all amployees
working a 7 hour day. When they work more than 7 hours this is calculated in
numbers and converted to time using the 24 hour clock method. However when
someone works less than 7 hours the time converison is shown as ##########.
Can anyone tell me how to make this display as a negative time please.
Thanks
working a 7 hour day. When they work more than 7 hours this is calculated in
numbers and converted to time using the 24 hour clock method. However when
someone works less than 7 hours the time converison is shown as ##########.
Can anyone tell me how to make this display as a negative time please.
Thanks