Thread: How to calculate time difference in hrs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default How to calculate time difference in hrs
A1 = 23/Nov 2300hrs
B1 = 25/Nov 0100hrs
C1 = Formula =(A1-B1)*24

"Will" wrote:

Dear All,

which functions shd i use to calculate the time difference between or with
ref. to 2 dates

i.e: 23/Nov 2300hrs - 25/Nov 0100hrs = 26hrs (result I want)
Reply With QuoteReply With Quote