Thread: function to give the number of hours
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
~L ~L is offline
external usenet poster
  
Posts: 177
Default function to give the number of hours
The formula for C1 would be =(B1-A1)*24

"force530" wrote:

I need a function that will result in the number of hrs between two times. If
there is no data, then blank. How do I get the result in C1 as in below?

a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5
Reply With QuoteReply With Quote