#1   Report Post  
Posted to microsoft.public.excel.misc
metaltecks
 
Posts: n/a
Default Time Formulas

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   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default Time Formulas


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 10:30 PM
searching a large database with a long list of search terms [email protected] Excel Discussion (Misc queries) 34 January 10th 06 06:23 AM
Time and motion chart deant Charts and Charting in Excel 0 September 21st 05 08:22 AM
Can series tool change formulas over time when used to copy them compu_trainer Excel Worksheet Functions 3 May 26th 05 07:55 PM
formulas for employee time sheets RJ Excel Worksheet Functions 1 January 15th 05 12:36 AM


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"