Agghhhh!!

Got it now......

Many thanks for all your help....

Everythings working smooth now.............

Cheers All

Dave :)))))))))))))





"Bob Phillips" wrote in message
...
You enter time as 7:45 not 7.45. Excel translates 7.45 as 7.45 days, which
is 10:48 on 7th Jan 1900.


"DB" wrote in message
k...
Got it Jim...

again tho......if I input 7.45...it displays 10.48....

is it anything to do with world time differences ?

Dave :)


"Jim Jackson" wrote in message
...
If you choose "Custom" instead of "Time" you can insert "hh:mm" if it is
not
already a choice.
--
Best wishes,

Jim


"DB" wrote:

Bob......when I goto format...the option is Time and then the available
choices are HRS/Mins/Seconds.....

Im selecting the area im using,,,,,,then in the Blue'd out
area......right
click......select Time.......

but it includes seconds.......and if I type something like 07.45 it
gets
displayed as 10.48.00 AM


Whats happening....I'm a bit confused

Dave :))


"Bob Phillips" wrote in message
...
C2: = B2-A2

format as hh:mm


"DB" wrote in message
k...
I want my worksheet to display the following time format....

Cell A.....Start time in Hours/Minutes eg 08.50

Cell B....Finish Time in Hours/Minutes eg 17.35

Cell C would = Cell B - Cell A .....showing the Hours/Minutes
someone is
at work.

I dont need to display the seconds as we arent that picky.

Im using UK time too


Thanks for any help...

Dave :)

P.S. I did try to post this earlier but it seems to have
disappeared - if
both somehow manage to appear then my apologies cos I didnt mean to
"multi Post"