B
bpc
I have time values as text (134 or 1614 for example) entered into a column
(J4) that I need to convert to a time value (1:34 or 16:14). Helpers cells
are ok but no VBA please. I have tried =IF(J4="","",TEXT(J4,"00\:00")) and
=IF(j4="","",MOD(j4,1)) to no avail as I need to peform another calculation
(thank you T Valko) on this data. Thoughts? If it helps I have the date for
the corresponding times in an adjacent cell(H4). BPC
(J4) that I need to convert to a time value (1:34 or 16:14). Helpers cells
are ok but no VBA please. I have tried =IF(J4="","",TEXT(J4,"00\:00")) and
=IF(j4="","",MOD(j4,1)) to no avail as I need to peform another calculation
(thank you T Valko) on this data. Thoughts? If it helps I have the date for
the corresponding times in an adjacent cell(H4). BPC