Time Calculations in hours and minutes for same day or different day

Forum|Forum|17 years ago
April 20, 2009
1 reply
973 views

I have a start date/time of 4/13/09 10:08 and end date/time time of 4/13/09 11:55 and I need to calculate the time between both. It would be one hour and 47 minutes on the same day.

If I use datediff with hh, it returns 1 (one hour). If I use datediff with mm, it returns 0. What is the correct way/formula to calculate the time difference to come out with hours and minutes, and how do I add the am or pm ?

If the end date/time is 4/14/09 11:55, then that would be one day, one hour and 47 minutes, or 25 horus and 47 minutes ? How is that done if the date is the next day ?

This topic has been closed for replies.

D

Dan_Bracuk

Inspiring

Reading your post, I was not able to determine what you are trying to accomplish. Having said that, it sounds like you want to get the datediff in minutes and do whatever math you need to do to get your hours.

Also, if these date objects are coming from a db, it would be easier to use your db's date functions instead of Cold Fusion's.

T

trojnfnAuthor

Inspiring

I am just trying to determine the time differenece between the start and end dates above, with the outcome in hours and minutes. I am on sql server and tried using sql datediff("hh",startdate,enddate) but that only returns the hour, using datediff("mm",startdate,enddate), returns 0, so how do I calculation to get the difference in hours and minutes.

D

Dan_Bracuk

Inspiring

First get it in minutes. Then, divide by 60 and do an int function on the answer. That will be the hours. Then do a mod(60) on the answer. That will be the minutes.

ps. read your reference material again for dateparts in sql server. Then you'll know why "mm" gives you 0.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded