ExcelBanter

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

tuibird

Excel?
 
5minutes 12secs minus 3 minutes 24sec,How do I do it in Excel ?

Bryan Hessey

Excel?
 

A1 0:5:12
A2 0:3:24
A3 =A1-A2
A3 shows as 0:1:48


tuibird Wrote:
5minutes 12secs minus 3 minutes 24sec,How do I do it in Excel ?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=484625



All times are GMT +1. The time now is 08:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com