OK. I thought you were saying it would produce am/pm notation. ex: 11:50
am without typing in the am/pm in the format string. Clever.


--
Regards,
Tom Ogilvy

Frank Kabel wrote in message
...
Tom Ogilvy wrote:
Just curious Frank
=IF(Front!B90,TEXT(MOD(Front!B9,0.5),"hh:mm") & "-"
&TEXT(MOD(Front!C9,0.5),"hh:mm"),"")

doesn't produce am/pm notation for me - xl97 SR2 US English - why
do you think it would do that? If it does it for you, perhaps it has
to do with your regional settings.

Hi Tom
That is what I was trying to say in my post :-)
This formula will produce times ranging from 00:00 - 11:59. So for
example converting the time 23:00 to 11:00 (a kind of am/pm notation
without trailing 'am/pm' text). I choosed this formula based on the
OP's example formula (which subtracted 12 from the time*24 if 12) -
therefore making some assumption about his requierements

Best regards
Frank