Time format control

  • Thread starter Thread starter Brad kennedy
  • Start date Start date
B

Brad kennedy

Hi everyone,

I have a time of 08:38 and would like to truncate the last minute by
using formatting to achieve 08:30. I currently do this using a formula
to remove the last minute. I have tried custom formatting of hh.m but
I still get 08:38. I have even tried hh.m"0" but get 08:380.

Any Ideas would be greatly appreciated.

Regards Brad
 
You can use this formula, it sounds as though you want round down to nearest
10th minute

=FLOOR(A1,1/144)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
If it is nearest half hour use

=FLOOR(A1,1/48)




--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Thanks Peo

The formula will be very handy and is different to how I currently do
this. The question still remains to see if this can be achieved by
using formatting rather than a formula. The reason for this is I wish
to keep the last right minute in the cell for other calculations but I
don't want to see it.

Also what do you mean by "For everyone's benefit keep the discussion
in the newsgroup". I have answered a question in the past for another
member but this is my first post (question) so I don't know what I did
wrong.

Regards Brad
 
Brad, that's my signature, it was not meant for you, you did nothing wrong.
It is just that I don't want
private emails sent to me with excel attachments and follow ups, any follow
ups
should be posted in the NG/forum. Since you are the 2nd person reacting
maybe I should
change it to "no private emails thank you" <g>
Anyway, thanks for the feedback. You could still use the full minutes, if
you use
a formula to round down values you can refer to the cell/value that is being
rounded.
AFAIK there is no way of not displaying the last minute, even if you format
it as h:m it will show

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top