Thread: Extracting time (hr:min) from date/time format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Extracting time (hr:min) from date/time format
Check out this reference...

http://www.cpearson.com/excel/datetime.htm#AddingTimes
--
HTH...

Jim Thomlinson


"lawandgrace" wrote:

I have data that is in date/time format in columns C and D that I want to
extract the time only so I can subtract and find out the actual hrs/minutes.

Example of data:

Column C Column D
8/1/2008 3:30 8/1/2008 13:55
8/2/2008 1:30 8/5/2008 4:30

Thanks!
Reply With QuoteReply With Quote