Time Formatting Problem
Hi gang,
okay so I get a report from another co-worker that I import data from into a main spreadsheet. One of the items I wish to import is a time (minutes played). When I import this column into my spreadsheet I see the time properly but its being read as hours instead of minutes. It looks like this 12:00 (which looks perfect, except when I go to add it up with other times, it's not accurate since it's not being considered in minutes). How can I convert them to minutes (and by this I mean 12:00 hrs is actually supposed to be 12:00 mins)? Thanks! Matt |
Time Formatting Problem
Nevermind, I figured it out :)
Used the following: =IF(ISNA(VLOOKUP(A3,PbyPQ3!$A:$S,14,FALSE)),0,VLOO KUP(A3,PbyPQ3!$A:$S,14,FALSE)/60) Matt "mpenkala" wrote: Hi gang, okay so I get a report from another co-worker that I import data from into a main spreadsheet. One of the items I wish to import is a time (minutes played). When I import this column into my spreadsheet I see the time properly but its being read as hours instead of minutes. It looks like this 12:00 (which looks perfect, except when I go to add it up with other times, it's not accurate since it's not being considered in minutes). How can I convert them to minutes (and by this I mean 12:00 hrs is actually supposed to be 12:00 mins)? Thanks! Matt |
All times are GMT +1. The time now is 09:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com