Good Day,

I am having issues with time formulas and been struggling for two days now. I am good at excel formulas just not time.

1) subtracting time and dates in the same field and displaying as text. It is the text part that is kicking my butt, I tried this

A1 B1 c1
3/3/2014 23:32:00 3/3/2014 23:33:58 =24*(b1-A1) but it gives me the wrong answer :-(


The next I am having issues with is because I can not get the time displayed as text correctly.

2) I need to pick out ones in C1 above that is less than 15, >15<30, >30<45, >45<1:00, etc in different columns. The <15 is easy it is the ones that are in between 2 times that i can't get (why I am trying to make the times text)

I am so stuck it is bad and I am starting to repeat my failures any help or push in the correct direction is greatly appreciated.

One day I want to understand time and dates in excel. I read and think I understand then this happens :-(.

Thank you,