Extracting time (hr:min) from date/time format

L

lawandgrace

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!
 
B

barry houdini

If you have a time/date in C2 you can get the time only by using thi
formula

=MOD(C2,1)

.....but what result do you expect from your data? The 2nd line has
different dates, don't you want to take the dates into account whe
calculating the difference
 
L

lawandgrace

My apologies. Yes, I do want to take the dates into account as well. What I'm
trying to do is get the actual number of minutes (subtracting column D from
column C) so I can figure an average time (I have over 300 rows of such
data). If I simply subtract column D from column C, where say 35 minutes
have transpired yet the dates are the same day, I get a result of 0.

Sorry for the inadequate description.
 
B

barry houdini

To get the number of minutes try like this

=(D2-C2)*1440

format result cell as numbe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top