Thread
:
time selection
View Single Post
#
2
Posted to microsoft.public.excel.programming
Sandy Mann
external usenet poster
Posts: 2,345
time selection
With that format how are you managing to enter zero days without it decoming
text?
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Don Doan" wrote in message
...
Hi,
I have 4 spreadsheets in my workbook called "master","1", "2", and "3".
In
column K of the "master" sheet, the cell format is 'dd h:mm:ss'.
How do i write a macro that would go through that column....if it's less
than 5 hrs then move the row (from colum A to K) to sheet "1"...if it's
between 5hrs and 24 hrs then move that row to sheet "2" and if it's more
than
24 hrs then move to sheet "3"...
the macro will keep on doing that until there is a blank line...
thanks.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann