ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/22708-formula.html)

mtw

Formula

How do I get the difference between to times without getting a "#VALUE!" error

Gord Dibben

For working with times see Chip Pearson's site for formulas and info.

http://www.cpearson.com/excel/datetime.htm#AddingTimes

Gord Dibben Excel MVP

On Tue, 19 Apr 2005 16:35:02 -0700, mtw wrote:

How do I get the difference between to times without getting a "#VALUE!" error

All times are GMT +1. The time now is 10:26 PM.