adding TIME through midnight calculates ok, but subtract doesn't
on a worksheet of timings, adding TIME through midnight calculates ok, but
subtracting time through midnight results in an error - any ideas on sorting this? |
adding TIME through midnight calculates ok, but subtract doesn't
Hi,
Use this general formula for tiimes spanning midnight and for thos that don't =(B1-A1+(B1<A1))*24 Mike "skipper" wrote: on a worksheet of timings, adding TIME through midnight calculates ok, but subtracting time through midnight results in an error - any ideas on sorting this? |
adding TIME through midnight calculates ok, but subtract doesn't
If you are using =B1-A1, try =MOD(B1-A1,1)
-- David Biddulph "skipper" wrote in message ... on a worksheet of timings, adding TIME through midnight calculates ok, but subtracting time through midnight results in an error - any ideas on sorting this? |
All times are GMT +1. The time now is 08:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com