Thread: number to time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Halls Stan Halls is offline
external usenet poster
 
Posts: 29
Default number to time

Help
I have 2 columns both with 4 digits as a time 1341 1415 . thease
fields are brought in from another system and can not be changed to a time
format what i am trying to do is work out the difference if it takes away
1341 from 1415 as a time rather than a number, so i get 34 as the result
instead of 74 as i get at present.

Thank you in advance for help

Stan