Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am currently working on a timesheet and its urgent that I can sort
something out today. we work on a flexi basis this lady has a contracted hours of 14:48 hours a work and she worked 12.21 hours last week but it doesn't seem to like to deduct time I think it should be -2.27 (2 hours 27 minutes) but it just comes up ############# I don't think it likes the minutes????? It works ok if she has worked over her contracted hours. Can anyone help me please. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
How can Excel do daily timesheet, -lunch time, & not use colon in. | Excel Worksheet Functions |