travel

Hi I was wondering if anyone was able to help. I have a set of data in one Sheet and I need specific Data from that sheet moved to a second sheet and a comment added. So For example Sheet 1 has Columns A through E with all employees data. I would need this data moved to sheet 2, which has...

I have a filtered list for expenses (LOA, Travel, Truck) each expense has a different value for a different employee, How can I come up with a subtotal in a separate cell? Total Expenses =$ ?? <colgroup><col><col></colgroup><tbody> Name Personnel Expenses Name 1 LOA Name 2 LOA, Travel...

Hi all, I'm trying to work out a a formula that avoids a circular reference. I have a list of numbers (hours taken), which is summed to give a total number of hours, converted to the nearest half day (based on an 8 hour day). e.g. if it sums to 9 hours, this rounds up to 1.5 days; 13 hours...

Hi, I am working on a chart that at the moment has three sections on the Y axis I would like to customize it so that the labels read Depot, Working, Collecting, Travel, Other Which would be determine by: Depot = 0.5 Working = 1 Collecting = 1.5 Travel = 2 Other = 0 Can anyone help please?

Hello... I have a list of text fields that have several names with numbers associated to each one of them of which i'm trying to sum and lookup onto another sheet that has the same text field but only one of them. For example. <colgroup><col><col></colgroup><tbody> Travel Offices 4,564...