Excel help

[kwyjibo]

Hi, does anyone have any idea how I can find the time duration between two dates/times in excel 2007 in minutes? Unfortunately the cell format is in the form of "YYYY.MM.DD HH:MM" so, for example:

-in A1 2012.01.01 00:00
-in A2 2012.01.01 00:30
-and I would like A3 to calculate automatically 30 minutes

I've tried just setting a custom cell format but that hasn't worked and I don't want to do a delimited text to column sort because it would mess up my other data

thanks

 

[kwyjibo]

Yeah that is the big problem, my dates/times are text (copied and pasted from elsewhere), but =TEXT(A2,"yyyy.mm.dd hh:MM")-TEXT(A1,"yyyy.mm.dd hh:MM") doesn't seem to convert it, any ideas?