Uffe Ö Posted March 21, 2005 Share Posted March 21, 2005 Hur får jag Excel att skriva ut antalet minuter från tidsformatet tt:mm? från tex. 7:07 vill jag ha ut 427. Link to comment Share on other sites More sharing options...
JonHansson Posted March 21, 2005 Share Posted March 21, 2005 =HOUR(A1)*60+MINUTE(A1) där A1 innehåller tiden [inlägget ändrat 2005-03-21 09:34:26 av Jon Hansson] Link to comment Share on other sites More sharing options...
08-Nalle Posted March 21, 2005 Share Posted March 21, 2005 Alternativ och enkel lösning. Om tiden finns i A1; =A1*24*60 OBS! Formatera formelcellen till tal! [inlägget ändrat 2005-03-21 09:49:13 av 08-Nalle] Link to comment Share on other sites More sharing options...
Pejo Posted March 21, 2005 Share Posted March 21, 2005 Hej! Ytterligare ett alternativ ... Det anpassade formatet [mm] visar en XL-tid i absoluta minuter. /Johan Link to comment Share on other sites More sharing options...
.thumb.png.71a73be41d8bf63826729db87e16f1ce.png)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.