Thread: calculate hours
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default calculate hours
=(A2-A1)*24 and format as General or Number, if you want the answer in
decimal hours.
--
David Biddulph


"gma" wrote in message
...
how do you calculate hours i.e.
3:45am-11:15am = ______hrs?


Reply With QuoteReply With Quote