Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time problem - Help please | Excel Discussion (Misc queries) | |||
Problem with formatting time | Excel Discussion (Misc queries) | |||
Time Problem | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |