How to convert date to number of hours in VBA?

Question

htaccess

There are: Excel, VBA and two dates.
From one date we subtract another and get the date / time: "01/10/1900 00:00:00"
How to display this date in the time format: "250:00:00"?
And we do all this with the help of a VBA script in Excel.

Answer 1

RewriteRule ^games/([^/]*)

This rule should be placed last.

RewriteRule ^games/finished/?$ index.php?do=games&t=finished [L]
RewriteRule ^games/live/?$ index.php?do=games&t=live [L]
RewriteRule ^games/shudle/?$ index.php?do=games&t=shudle [L]
RewriteRule ^games/shift/?$ index.php?do=games&t=shift [L]
RewriteRule ^games/([^/]*)/?$ index.php?do=games&date=$1 [L]

Answer 2

Is the formula enough?
In general, a date in Excel is a fractional number, where the integer part is the number of days from some date, and the fractional part is the number of seconds or ml.sec. In general, if you take the whole part and multiply by 24, you get the number of hours.
For VBA, there is a DateDiff function that returns the difference between two dates in given intervals. For example, to get the difference in hours between two dates:
DateDiff("h", date1, date2)

Answer 3

Let's be late BUT ...
1. we have 2 cells (A1 and B1) that contain dates
2. in C1 we write the formula = B1-A1
3. in cell C1 RMB-Cell Format - Time - select the format like 35:00: 00
Profit