Forum

Sam Naughtin
@samn
Forum Home   |   Recent Posts
Active Member
Joined: Apr 10, 2024
Profile Activity
Topics: 3 / Replies: 2
AllTopicsReplies
Reply
RE: Need help with formula to generate a sequence number per employee, perday, per clock time

Thanks very much for your help!

8 months ago
Forum
General Excel Questions & Answers
Topic
Need help with formula to generate a sequence number per employee, perday, per clock time
8 months ago
Forum
General Excel Questions & Answers
Replies: 2
Views: 96
Topic
How to split employee shifts into separate shifts when gap of 1 hour or more
1 year ago
Forum
General Excel Questions & Answers
Replies: 1
Views: 165
Reply
RE: File with US dates, some as Data and some as text, need to convert to AU format dates

Thanks, power query is not an option in this case, I ended up writing this formula which semed to work. =IF(ISNUMBER(C3)=FALSE,DATE(RIGHT(C3,...

1 year ago
Forum
General Excel Questions & Answers
Topic
File with US dates, some as Data and some as text, need to convert to AU format dates
1 year ago
Forum
General Excel Questions & Answers
Replies: 3
Views: 117