View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DeBosuil DeBosuil is offline
external usenet poster
 
Posts: 2
Default Compute time differences


What formula will compute the number of hours and minutes between the Start
Time and the End time in each row?

(Each cell is formatted as number, custom, type: h:mm AM/PM)

Excuse for mistyping in the first respose.

Use formule(A2B2)+B2-A2

Cel set hh:mm
Use no PM/AM but 24 hours

Regards



--
--------------------------------- --- -- -
Posted with NewsLeecher v7.0 Beta 10
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -