Thread: time in minute format
View Single Post
 
Old 12-15-2015, 12:05 AM
xor xor is offline Windows 10 Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If I understand you correct
A1: 10:20
A2: 8:40
A3: =A1-A2

Then =HOUR(A3)+MINUTE(A3)/60 formatted General
Reply With Quote