Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have scanned a telephone account which shows the duration of a call as
min:sec (eg.15:35). Using an OCR program I have imported this data into Excel which picks the time up as hh:mm format. is there anyway to get Excel to read it as minutes and seconds instead of hours and minutes without going thru every record and adding a 0: (to hold the hour place)??? Thanks Helen |
#2
![]() |
|||
|
|||
![]()
Hi
Enter the number 60 into some free cell and copy it. Select the range with your data, and then PasteSpecialMultiply. OK. Format rhe range as "mm:ss". Don't forget to scrap the number 60 entered before. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "HMB" wrote in message ... I have scanned a telephone account which shows the duration of a call as min:sec (eg.15:35). Using an OCR program I have imported this data into Excel which picks the time up as hh:mm format. is there anyway to get Excel to read it as minutes and seconds instead of hours and minutes without going thru every record and adding a 0: (to hold the hour place)??? Thanks Helen |
#3
![]() |
|||
|
|||
![]()
I think you mean
PasteSpecialDivide HTH. best wishes Harald "Arvi Laanemets" skrev i melding ... Hi Enter the number 60 into some free cell and copy it. Select the range with your data, and then PasteSpecialMultiply. OK. Format rhe range as "mm:ss". Don't forget to scrap the number 60 entered before. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "HMB" wrote in message ... I have scanned a telephone account which shows the duration of a call as min:sec (eg.15:35). Using an OCR program I have imported this data into Excel which picks the time up as hh:mm format. is there anyway to get Excel to read it as minutes and seconds instead of hours and minutes without going thru every record and adding a 0: (to hold the hour place)??? Thanks Helen |
#4
![]() |
|||
|
|||
![]() "Harald Staff" wrote in message ... I think you mean PasteSpecialDivide Sorry! It must be this cold, I have at moment! -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) |
#5
![]() |
|||
|
|||
![]()
Thanks for this. Have tried it out on some dummy data at home and when I get
to work tomorrow I think it'll do the trick. And I guess by putting the [ ] around the mm on the format, I can get it to show a sum over 59 minutes as well!! Awesome! "Arvi Laanemets" wrote: "Harald Staff" wrote in message ... I think you mean PasteSpecialDivide Sorry! It must be this cold, I have at moment! -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing MM:SS From Tab Delimited File and Charting | Charts and Charting in Excel | |||
How do I add time (in mm:ss) from multiple worksheets? | Excel Worksheet Functions | |||
The HH:MM function | Excel Discussion (Misc queries) | |||
Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions |