Search results

Why reinvent the wheel - thank you for your quick response. However I can't download anything in work or use usb - its like Fort Knox! Any other recommendations please?

Hello People I need some help please. I get constantly distracted and want to log distraction easily. Is it possible to have a stop and start vba macro, which logs the date (dd/mm/yy) in one column, the time in the other (i'll fill time bandit manually) Hopefully over a month it will...

Hi Hui, my name is Stu :D Thanks for the reply. I managed to work it out. So, i used the following formula: Return multiple records http://www.get-digital-help.com/2009/10/25/how-to-return-multiple-values-using-vlookup-in-excel/ =INDEX($A$2:$C$7, SMALL(IF($B$9=$A$2:$A$7...

That didn't work. Try this site instead: http://www.freeuploadsite.com/do.php?id=1201 Thanks

I'm currently in the progress of creating a spreadsheet but stuck and need some help please. I need to be able to find and return all values for the selected month and handle errors if the formula don't return any values. To sanity check what is returned, i will need a formula to count all...

Hi, as NARAYANK991 has put my requirements so elegantly in writing (thanks NARAYANK991), can anybody advise a way to produce this so its automated based on the date/time? Thanks SN

Sorry just quickly made up the data - My hard drive got coruppted so lost all my data :( Your understanding is totally correct.

Sorry for the delay, an example of time worked: Date Day StartTime End Time Break Total Hours Overtime 16/06/2012 Sat 16:30 02:00 00:00 10:30 17/06/2012 Sun 10:00 20:00 00:00 10:30 06/07/2012 Fri 12:00 01:00 00:00 13:00 12/07/2012 Thu 12:00 22:40 00:00 10:40 1. I need to the total time...

The software is a good idea (very good idea) But its only 3 of us that will be using it - now that overtime is very limited we won't need as often. Can someone explain the huge formila please? Anyone able to handle days of weekends? Thanks

Debraj, please can you break down the formula as i'm not sure what its doing: =TEXT(CONVERT(SUMPRODUCT(LOOKUP(ROW(INDIRECT(CONVERT(B2,"day","mn")&":"&CONVERT(C2,"day","mn")-1)),$I$2:$I$6,$K$2:$K$6)),"mn","day"),"[hh]:mm:ss") Any help in handling weekday and weekends? I failed to mention...

Apologies for the reply all anf thanks for your prompt replies- had an internet outage in work :O so had to sort that out (which will be logged on my new spreadsheet. bobhc - Thanks for the reply - My name is almost as bad as fagley dork...

Hi, I'm having a nightmare creating a spreadsheet to help me automate my overtime procedure. I want the end product to work out the total over time based on date, start time and end time i enter. I have different overtime policies for weekdays and weekends. For example Weekedays...