Hi mudraker!

Usually the need for conversion is that the time is going to be used
in a subsequent calculation of wages etc.

You solution returns text. Although using =B1*2 will coerce your
formula to text, you'll still get problems with functions such as SUM
which will treat the return as zero.

So where there is a potential need for use in calculations:

=--(HOUR(A1)&"."&(MINUTE(A1)*100/60))

You'll still get problems if the formula is used on times in excess of
24:00 (formatted aggregates [hh]:mm). In that case your formula will
only return the modulus of the hours divided by 24. You could get
round this by incorporating a DAY in your calculations but...

Far easier and safer to multiply by 24.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"mudraker " wrote in message
...
a1= 2:45

=HOUR(A1)&"."&(MINUTE(A1)*100/60)


---
Message posted from http://www.ExcelForum.com/