Search results for query: *

if an employee clocked in @ 5P one day and clocks out @ 2 AM the next day in a RECORD. It'll say start time: StartTime: 5PM EndTime: 2AM (this record is attached to the previous days date) it should say 9 hours worked. Please help

How do I get a datedif function to take into account an overnight end time. I need to calulate hours worked, some employees come in at say 5P but leave at 1A the next day. I'm getting negative numbers on the calculation. PLEASE HELP!

i'm going to save it as a text file in the end anyway i'll fix the type issues in access where i actually know what i'm doing. thanks again for your help, i hope i don't run into issues with what you were talking about.

i sent it i took the code out before i sent it any help is soooooooooooooooooooo appreciated

run it as a macro in excel right?

yes, i sware

it never gets to it

when i mouse over If Trim(.Value)<value. it says .value=<object variable or With block variable not set>

it goes to this one If Trim(.Value) = "" Then . ...but skips this one Value = .Offset(-1).Value

it is staying stuck on the first line does there need to be a loop?

it doesn't error out. if i step through it seems like it works but there aren't any changes. please be patient with me, i really need the help

it is staying stuck on A2

I DID CHANGE THE REF TO A2 SINCE THE HEADERS ARE ON 1 Sub Test() Dim c As Range, r As Range With ActiveSheet For Each c In .Range(.[A2], .[A2].End(xlToRight)) For Each r In .Range(.[A2], .[A2].End(xlDown)) If...

I run it as a macro right? I've never coded in Excel.

Intersect(r.EntireRow, c.EntireColumn).Value = _ Intersect(r.EntireRow, c.EntireColumn).Offset(-1).Value it skips both of these lines

it's not determining that the cells are empty and is bypassing the rest of the code.

it is skipping the line Intersect(r.EntireRow, c.EntireColumn).Value = _ I tried value<>"" and that didn't work PLEASE HELP

I can't get this to work in excel. it doens't error out though.

is this code supposed to go in excel?

it errors out on compile error: user type not defined and it highlights "c As range