=(INT(A1/100)+MOD(A1,100)/60)/24

and format as time

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"QD" wrote in message
oups.com...
Can anyone help me to convert the format of time entered from HHMM to
HH:MM in the same cell.

For example:
Date entry converts to, in the same cell
0840 08:40
1150 11:60

Thanks
QD