Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
phrase to equal a number in time sheets(al=5hours)
i have done a rota for times work starts and finishes,and also a formula for
amount of hours worked in a week,but when i enter al(for annual leave) it messes up my formula,is there ne way i can get AL to equal 5 hours worked |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
phrase to equal a number in time sheets(al=5hours)
angellous wrote:
i have done a rota for times work starts and finishes,and also a formula for amount of hours worked in a week,but when i enter al(for annual leave) it messes up my formula,is there ne way i can get AL to equal 5 hours worked I think it would be better if you could upload a small example file to www.rapidshare.de, because I understand quite nothing... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format number to Time in Excel? | Excel Worksheet Functions | |||
Selecting the first time a number appears (part 2) | Excel Discussion (Misc queries) | |||
format a six figure number to a time. | Excel Discussion (Misc queries) | |||
set number of rows equal in mutiple columns | Excel Discussion (Misc queries) | |||
putting a number equal to writing commands | Excel Worksheet Functions |