View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default calculating time

XL stores times as fractional days, so multiply by 24 hours per day to
get hours:

=(B1-A1) * 24

In article <779ad662a28a3@uwe,
"Emerogork via OfficeKB.com" <u36894@uwe wrote:

7:00am int A1, 3:00pm in B1. When I (B1 - A1) I get 0.33 but I want 8.
Thoughts?