Thread: Time in Minutes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Time in Minutes

Thank you for your help - Is that a custom format?

"David Biddulph" wrote:

You could use =(G5-C5)*24*60 and format as 00 "min"
--
David Biddulph

"Karen" wrote in message
...
This is the scenario:

Cell G5 = 1: 39 AM
Cell C5 = 12:56 AM
Cell I5 = (Formula) =G5-C5

The result is 0:43
Is there any way to return a result of 43 min. instead of 0:43?

Any help would be greatly appreciated - Thank you, Karen