Posts by iancox01

Forgive me - that works - many thanks. Was the problem that i was trying to collect the information as a string?

Cheers

Ian

Thanks Roy. Sorry I missed the question.

The times are collected by a fingerprint machine when staff arrive and leave for work - it is used to calculate their hours so they can be paid correctly.

Thanks for the code - which is excellent - I just need to solve the problem with the display of the data and I can use it.

Cheers

Ian

this shows the partial collection ...

Hi Roy

It does remove all wrapped text from all cells but unfortunately doesn't solve the problem.

When run, Cells (7.35) shows the text wrapped again (even after all cells having wrapping removed )

And the value collected in the code is still the same "06:57 - it won't collect all of the information.

If you run the code on the attached which includes your changes, you will see what I mean.

Thanks

Ian

TimesheetProgram.xlsm

Thanks Roy - see attached.

The plan is:

1) Collect the start time and end time from the cell

2) Calculate the total time worked

3) Round up or round down

4) Display all data on different tabs depending on the department

5) Finally look for anomalies where there is only a check in time and create a list to be manually adjsued.

I am happy with all the steps as long as I can get a variable with the full data in it! I am manipulating as numbers as find that easier for what I want to do.

Many thanks

Ian

TimesheetProgram.xlsm

Thanks again.

So that removes the wrapping which is great - thanks very much, And the cell shows as just one string - eg 06:5317:07 - but the program still only picks up the 06:53. See below for the screenshot and the code I am using.

Sorry to be a pain but it is causing much head scratching and stopping me completing my program. Thanks again for all of your help.

Cheers

Ian

Thanks Roy

The only issue is that the two times are in the same cell - so not A3 and A4 - but just A3. I have screenshotted a a small part of the spreadsheet - attached - to show. So in this case if I add FullTime=cells(3,1) I only get "06:59 shown - not the rest of the contents and not the second speech marks.

I was expecting 06:5917:28 or "06:5917:28"

Many thanks

Ian

I have a workbook that has a start time and end time on two rows in multiple. I am trying to collect all the data in a macro so I can manipulate it.

One row example

06:21

17:05

When I try and collect it it using VBA just gives me "06:21. But if I go to the worksheet and copy it into another cell (eg =B6) then it gives me 06:2117:05 which is what I want to collect using the macro!

Can anyone please help as it is driving me crazy!

Many thanks

Ian