View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default Adding Date/Time fields

Assuming they are actually Excel datetime fields.
B2 is the start time
C2 is the finish time

If you just have the time component without the date
=C2-B2-b2+(B2C2)

If you have the date and time (timestamp)
=C2-B2

More information on Date & Time
http://www.mvps.org/dmcritchie/excel/datetime.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"teastman" wrote in message
...

12/31/05 - 08 Hrs 10 Mins
01/01/06 - 01 Hrs 00 Mins

How do I add these two fields ? I don't need the date, just adding the
times.


--
teastman
------------------------------------------------------------------------
teastman's Profile: http://www.excelforum.com/member.php...o&userid=30030
View this thread: http://www.excelforum.com/showthread...hreadid=497168