Subtracting Dates

G

Guest

I have two dates and times and the formula is subtracting one date from the other. The dates are exactly 24 hours apart, but is showing 0 hours rather than 24
2/19/04 12:00 AM 2/20/04 12:10 AM =TEXT(P5-O5,"h"

The formula appears to be working in all of the other columns

Also, is there a way to find the difference in business hours between these dates? Some days are more than one day apart

Thank
 
F

Frank Kabel

Hi
try the following
=P5-O5
and format this cell with the custom format [hh]:mm
or use
=TEXT(P5-O5,"[hh]")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
Problem with NetworkDays ... Inconsistent results 0
years-months-days-hours 5
Dates between cells in one column and another 5
How to I subtract two dates & times to obtain a time 19
how can we calculate the numbers of hours between two dates and 4
Difference between dates and times 5
Access DateDiff function 0

Top