Printing times

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Thanks for reading.
Ready to finish my sheet but have 1 small (i hope) problem.
How can I print times in the cells like this...
Col B2
7:15
27
35
8:07
33
58
9:22
from 7:00 to 10:52
put the 1st hour and min in for that hour and just the min for the
remaining of that hour, then start over again. I have several
column's whith these times in from row 3 to row 57.
They are like this in the sheet I have now
Col B2
7:15
7:27
7:35
8:07
8:33
8:58
9:22
from 7:00 to 10:52

Thanks all for the help I've ask in the past, I learned lots from
this group.
Bobby
 
Thanks for reading.
Ready to finish my sheet but have 1 small (i hope) problem.
How can I print times in the cells like this...
Col B2
7:15
27
35
8:07
33
58
9:22
from 7:00 to 10:52
put the 1st hour and min in for that hour and just the min for the
remaining of that hour, then start over again. I have several
column's whith these times in from row 3 to row 57.
They are like this in the sheet I have now
Col B2
7:15
7:27
7:35
8:07
8:33
8:58
9:22
from 7:00 to 10:52

Thanks all for the help I've ask in the past, I learned lots from
this group.
Bobby
Click to expand...

I didn't word this right, the times are on the sheet as
Col B2
7:15
7:27
7:35
8:07
8:33
8:58
9:22
Click to expand...
but when I print the sheet I want them to look like this
Col B2
7:15
27
35
8:07
33
58
9:22
Click to expand...
or am I asking too much from Excel?
Thanks
Bobby
 
Hi
possible with a helper column, but to be honest I would simply enter
the complete time value :-)
 
Thanks Frank
I do enter the complete time now due to the fact I do calculations
off of them. But I wanted just the print out to be different. You
still think I'm better off printing the whole time format?
May I ask what is a column helper?

Thanks
Bobby

Fri, 15 Oct 2004 17:22:11 +0200, "Frank Kabel"
 
Hi
you could use a separate formula in an adjacent cell. Something like
the following formulas
B1:
=TEXT(A1,"hh:mm")
B2:
=IF(HOUR(A1)=HOUR(B1),MINUTE(A2),TEXT(A2,"hh:mm"))
and format this column as General and copy down for all rows.
 
Frank nailed it for you. You may want to pretty up your display b
changing the "MINUTE(A2)" portion of the formula by adding ":"& i
front, i.e. ":"&MINUTE(A2). This will have your display of minute
only preceeded by a colon

:25

HTH

Bruc
 
Thanks guys, don't know if I'm going to use that last tip or now,
maybe later. Finished my sheet, with the help of all...
Thanks again
BobbyOn Fri, 15 Oct 2004
 
Back
Top