How can I compute date to hours? For example I want to compute how many hours past during July 23 to the current date(July 25 in our country).
Outputting it like this:
Total Hours past: 48 Hours
Asked
Active
Viewed 1,287 times
1
NatsuDragneel
- 297
- 1
- 4
- 21
-
You care about the time part as well or only date? i.e. The hours will be different depending on what time on 23rd July you compare current date time with – shree.pat18 Jul 25 '14 at 02:38
-
1[TimeSpan](http://msdn.microsoft.com/en-us/library/system.timespan.aspx) will give you minutes, hours, milliseconds, whatever you want see also [How to format a TimeSpan object in .NET](http://stackoverflow.com/q/574881/1070452) – Ňɏssa Pøngjǣrdenlarp Jul 25 '14 at 02:41
-
@shree.pat18 both actually, thanks for pointing it out. – NatsuDragneel Jul 25 '14 at 02:45
-
@shree.pat18 Can it actually convert days into hours? – NatsuDragneel Jul 25 '14 at 02:45
-
@Plutonix I'm trying to compute the intervals between 2 dates then converting the answer into hours. – NatsuDragneel Jul 25 '14 at 02:46
-
the third example snippet in the TimeSpan link shows how to subtract dates and get the interval. please show what you have tried and where the dates come from. – Ňɏssa Pøngjǣrdenlarp Jul 25 '14 at 02:49
-
[DateDiff](http://msdn.microsoft.com/en-us/library/b5xbyt6f(v=vs.90).aspx) – OneFineDay Jul 25 '14 at 02:58
2 Answers
0
I suspect there is more lurking below the surface like how you get the dates into your code. If one date originates from another country, you will have to take that into consideration. Hard to be clearer without code.
Dim thisDate As DateTime = #2/10/2010#
Dim thatDate As DateTime = #10/21/2013#
Dim ts1 As TimeSpan = thatDate.Subtract(thisDate)
' or:
' Dim ts1 As TimeSpan = thatDate - thisDate
Console.WriteLine("{0} Days or {1} hours have passed",
ts1.TotalDays, ts1.TotalHours)
Output:
1349 Days or 32376 hours have passed
Ňɏssa Pøngjǣrdenlarp
- 38,411
- 12
- 59
- 178
-
Sorry for not showing any code I'm at my code at another workstation – NatsuDragneel Jul 25 '14 at 03:06
-
-
days, hours, seconds, milliseconds, years, months, clock ticks - all already computed for you – Ňɏssa Pøngjǣrdenlarp Jul 25 '14 at 03:07
-
I mean the output is it possible to become hours? Sorry, I'm not familiar with vb. – NatsuDragneel Jul 25 '14 at 03:11
-
what do you mean "become hours"? timespan tells you the span of time (in all manner of increments) between 2 dates. if the dates are 2 days apart it will be 48 hours – Ňɏssa Pøngjǣrdenlarp Jul 25 '14 at 03:14
0
Private Sub days_calc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim d1 As Date = "24/07/2014" ' From date
Dim d2 As Date = "24/08/2014" ' To date
MsgBox("Date difference in days : " & (d2 - d1).TotalDays & "Days")
MsgBox("Date difference in hours : " & (d2 - d1).TotalHours & "Hours")
MsgBox("Date difference in minutes : " & (d2 - d1).TotalMinutes & "Minutes")
End Sub
Suji
- 1,326
- 1
- 12
- 27