L
Leo Missler
Hi, I want to substract 2 date/time combi cells to get
throughput time in minutes or days, hours and minutes.
Example
In cell A1 "12/08/2003 12:15" (dd/mm/yyyy hh:mm)
In cell B1 "13/08/2003 08:00" (dd/mm/yyyy hh:mm)
When I use only date or only time it all goes well, but
when I use the date and time combination in one cell it
goes wrong.
Anyone suggestions to solve my problem?? (The inputdata
comes from another source, and I'm not able to change this)
Th@nx in advance
Leo Missler
Netherlands
throughput time in minutes or days, hours and minutes.
Example
In cell A1 "12/08/2003 12:15" (dd/mm/yyyy hh:mm)
In cell B1 "13/08/2003 08:00" (dd/mm/yyyy hh:mm)
When I use only date or only time it all goes well, but
when I use the date and time combination in one cell it
goes wrong.
Anyone suggestions to solve my problem?? (The inputdata
comes from another source, and I'm not able to change this)
Th@nx in advance
Leo Missler
Netherlands