Thread: Format Cells to calculate hours and minutes taken to complete task
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AndyO_UK AndyO_UK is offline
external usenet poster
  
Posts: 15
Default Format Cells to calculate hours and minutes taken to complete task
Hi

I have the following calculation in my column E:
=((D3-C3)*24)-(NETWORKDAYS(C3,D3)*24)+24

Column D is Date/Time order completed in format: dd/mm/yyyy hh:mm:ss
Column C is Date/Time order received in format: dd/mm/yyyy hh:mm:ss

Currently my results in column E return 0.17 which equates to 10 minutes - I
really want it to show 10 minutes and not 0.17

Can anyone help?
Reply With QuoteReply With Quote