View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scoops Scoops is offline
external usenet poster
 
Posts: 108
Default Calculating time difference in minutes


jonhunt wrote:

Scoops,


I had already tried the other suggestion of 1440 and that doesn't seem
to work.


Hi Jon

Both David's and daddylonglegs solutions work fine for me, though I did
amend them to
=24*60*-(B6-C6)
and
=(B6-C6)*-1440
to change the +/-

Is your data ok?

Regards

Steve