Thread: Using Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DB DB is offline
external usenet poster
 
Posts: 45
Default Using Time

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"