Thread: HELP! … I have a column in a spreadsheet that is formatted as follows
View Single Post
 
Old 08-21-2014, 08:21 AM
zztops51 zztops51 is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Aug 2014
Posts: 1
zztops51 is on a distinguished road
Default HELP! … I have a column in a spreadsheet that is formatted as follows
HELP! … I have a column in a spreadsheet that is formatted as follows:
2 H, 15 M
12 H, 9 M
12 H, 15 M
2 H, 9 M
…
I need to convert it to hours as:
2.25
12.15
12.25
2.15
…
Ideas?
Reply With Quote