View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chappy
 
Posts: n/a
Default Subtracting 2 hours from time

Hiya,

I've got a prob which is probably very easy to fix but is leavin me
scratchin my head.

I've got time set in cells and want to take 2 hours from this value. So I'm
trying to change, say, 1:30 to 23:30 etc.

any ideas?? Thanks.