converting mins to hrs & mins

• Chris Wood-276135

  SSC Enthusiast

  Points: 101

  More actions

  February 2, 2006 at 5:58 am

  #167415

  hi,

  I have an application that gives all of its times in mins as an integer. I needed to convert this to mins, hrs, days(8hrs) to get some meaningful reports for the Users.

  my programming skills are pants , even i can get the hrs by dividing by 60, but is there a function or something from this to give me the remainder so i can work out the mins?

  can anyone help please.

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  February 2, 2006 at 6:25 am

  #618359

  DECLARE @minutes INT

  SET @minutes = 200

  SELECT @minutes / 60 AS hours

  , @minutes % 60 AS minutes

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Chris Wood-276135

  SSC Enthusiast

  Points: 101

  More actions

  February 2, 2006 at 6:34 am

  #618362

  thanks chris, i had just found the modulo in BOL...

  i am trying to add a day into the equation after every 8 hours, is this just as simple?

• Joe Nakanishi-3

  SSC Eights!

  Points: 828

  More actions

  February 2, 2006 at 8:46 am

  #618423

  More or less...

  DECLARE @minutes INT

  SET @minutes = 2000

  SELECT @minutes / (60 * 8) AS days, @minutes % (60 * 8) / 60 AS hours, @minutes % (60 * 8) % 60 AS minutes