Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a formula in column s that calculates the difference in time from two
other columns. Then in column T, the answer of column s is converted into actual minutes. I need to create another formula, but everytime I use the converted minutes in column T, it gives me an error. Is there a way I can calculate with these numbers as is, or do I have to change them to general numbers, and then run my formula? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Sounds like you might be converting to minutes by using some sort of TEXT formula. If so then you might have a problem using the result if it's text. To calculate the difference between two time values in minutes =(B1-A1)*1440 format as number -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=527789 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
Time and motion chart | Charts and Charting in Excel | |||
Can series tool change formulas over time when used to copy them | Excel Worksheet Functions | |||
formulas for employee time sheets | Excel Worksheet Functions |