Software

Ask something
Discussion Locked

How to calculate difference if Date and

0 helpful
1 reply

by a former member

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
how to calculate difference between date and time if Date is separate filed and Time is a separate "TEXT" field. please HELP

1 reply

by dklippert

If the Time field is laid out correctly ( 6:00 PM), You can use add the date and time and then find the difference. Assuming Date in A1 and A2 and Time in B1 and B2:

=(A1+B1)-(A2+B2)
The result shoud be formatted as a number or something like [h]:mm.
See:
www.cpearson.com/excel/datetime.htm

This discussion is closed to new replies.