numbers to h:mm conversion

Dennisr53

New Member
Joined
May 29, 2015
Messages
38
Hi everyone,

I was given a spreadsheet where someone typed in 1224 and it was supposed to be 12:24. I have over 1500 of these type of errors. Is there a way to correct them without having to retype each of them?

Thanks, Dennis
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
Row\Col
A​
B​
C​
1​
1224​
12:24​
B1: =DOLLARDE(A1/100, 60)/24
2​
Format of B1: h:mm
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
You're welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,275
Messages
5,467,709
Members
406,549
Latest member
midcoastchris04

This Week's Hot Topics

Top