Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Subtract 7:00 pm from 7:30 pm

As NIKE says; Just do it:

=B1-A1

But you want some theory on it as well I believe. See Chip's page and further links
http://www.cpearson.com/excel/datetime.htm

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Lhall" wrote in message news:Ina1b.218262$Ho3.28527@sccrnsc03...
Hope someone can help... I need to get the difference between two times ie:
End - Start.
I guess I need a formula that I can use in Excel that will allow me to enter
the start time, the end time, and then in another cell, get the difference.

So, If I start a job at 7:00 PM (Which is how I enter the info in the cell)
and end the job at say 9:45 PM (entered in the second cell) the third cell
will display 2 Hr 45 min.

I think I am explaining this badly... I guess what I need is to be able to
perform math (Add/Subtract) on Time. I am not familiar with how Excel uses
Time Values.

Begin End Total
7:00 PM 7:30 PM 30 min

Hope someone can help
Larry




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
How do i subtract 3 hrs from now()? Andy Excel Worksheet Functions 9 April 29th 23 11:44 AM
subtract uindt Excel Worksheet Functions 1 April 29th 08 05:05 AM
how do i add and subtract kim New Users to Excel 4 December 22nd 07 12:10 AM
subtract henryshuttle Excel Discussion (Misc queries) 2 June 26th 06 05:05 PM
how to subtract one row from the other? prasad Excel Discussion (Misc queries) 1 April 8th 05 08:38 PM


All times are GMT +1. The time now is 10:14 PM.

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

About Us

"It's about Microsoft Excel"