Converting time-formatted to text-based data
- From: Zakynthos <Zakynthos@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Nov 2008 06:58:01 -0800
I'm setting up several thousand contract names for a workforce management
program from time-formatted data in Excel and am hoping there might be a way
using a VB script to look up the value of a cell and convert it to form part
of the unique name given to that contract.
Example: the data running from Sunday start attendance to Saturday end
attendance is contained in, say, cells: c110-p110
00:00 00:00 08:00 16:00 08:00 16:30 08:00 16:30 08:00 16:00 08:00 16:00 00:00 00:00
The standard part of the contract name I need to generate is: "FT NR 36",
followed by:
M (8h-16h),Tu (8h-16h30), W (8h-16h30), Th (8h-16h), F (8h-16h)
The 00:00 values in start end of first 2 cells (Sunday) c110 & d110 and last
2 cells (Saturday) o110 & p110 should return no values in the heading, as
shown above. If there was data in these cells it should return S(start-end
hrs) and Sa (start-end hrs) in the same format as the Mon-Fri attendances
shown above.
Many thanks for any advice
.
- Follow-Ups:
- Prev by Date: For next do loop issue
- Next by Date: Re: Help with script: STARTING A NEW SUB.. (within sub?)
- Previous by thread: For next do loop issue
- Next by thread: RE: Converting time-formatted to text-based data
- Index(es):
Relevant Pages
|
