C
Craigger
I want to take the difference in two times and figure out how many hours and
minutes there are between them. I already have this working, but my question
is how to display it in hours and minutes. This is what I have:
F35 - 7:30:00 PM
F36 - 11:05:00 PM
F37 - =IF(G35>F35, (G35-F35)*24, (1+G35-F35)*24)
F37 has that formula, but will display 3.58, which means 3 hours and 58/100
of an hour. I would rather this display as hours and minutes. How do I make
it do that? If anyone can help, I would appreciate it.
Craig
minutes there are between them. I already have this working, but my question
is how to display it in hours and minutes. This is what I have:
F35 - 7:30:00 PM
F36 - 11:05:00 PM
F37 - =IF(G35>F35, (G35-F35)*24, (1+G35-F35)*24)
F37 has that formula, but will display 3.58, which means 3 hours and 58/100
of an hour. I would rather this display as hours and minutes. How do I make
it do that? If anyone can help, I would appreciate it.
Craig