Thread: Time format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NoodNutt NoodNutt is offline
external usenet poster
  
Posts: 221
Default Time format
G'day PD

Assume:

A1 = Start Time 'Format h:mm
B1 = Finish Time ' Same format

C1=IF(A1="","",MOD(B1-A1,1))

Change cell references to suit
Copy down as required

HTH
Mark


Reply With QuoteReply With Quote