How I did it!
I entered 18:00 in A1, 17:18 in B1 and =A1-A2 in C1. And guess what, C1 showed 0:42. That's what you want?
If I were you, I shouldn't use a decimal point. 17.18.00 isn't a valid number, nor a valid time, so it's interpreted as text. And you can't subtract texts (try: "John Doe" minus "Barrack").
As for formatting without seconds, try custom format (last choice in the box). Then hh:mm
It's as simple as it can be, once you know it.
Does anybody know how to take one time away from another ie 17.18.00 away from 18.00.00 = 42mins.
The cells concerned are formated in Time hh.mm.ss
Taking the 17.18.00 from the 18.00.00 leaves me with a #VALUE!
Also how do you show the time without the seconds.
I've looked in format cells but all formated time seems to have the seconds included.
Many Thanks in antisipation of your replies.