Hello, I was wondering if anyone can help me out. I am creating a for
to help in scheduling staff. Right now my problem is that whenever
enter 1:30am as a time and then copy that cell's contents to anothe
page it copies as 1.5. To keep things simple for the staff it work
like this, I enter everybodys start time and end time on one page, the
on the printable page it checks to see if there is a start time, i
there is it prints [Start time]-[End time].

Here is the equation that I am using, I don't really know that muc
about macros or anything like that so it's fairly complicated.

=IF(MAX(Front!B9)=0,"",IF(Front!B9*24=12,Front!B9 *24-12,Front!B9*24)&"-"&IF(Front!C9*24=12,Front!C9*24-12,Front!C9*24))

So if I enter 10:30am for the start time, and 7:00pm for the end tim
it diplays "10:30-7", but for 5:00pm as the start and 1:30am as the en
it displays "5-1.5"

Any help would be appreciated

Benwi
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message377075.htm