Kako dodati ali sešteti krat v 24 urah v Excelu?
Običajno boste pri dodajanju ali seštevanju časov v Excelu končno izračunani rezultat dobili v 24 urah, kot je prikazano na levi sliki zaslona. Kaj pa dodajanje ali seštevanje krat v 24 urah za prikaz resničnega rezultata? Ta članek vam lahko pomaga.
Samo spremeniti morate obliko celice z rezultati, da jo dosežete. Naredite naslednje.
1. Po seštevanju časov izberite in z desno miškino tipko kliknite celico z rezultati, nato izberite Oblikuj celice v meniju z desnim klikom. Oglejte si posnetek zaslona:
2. V Ljubljani Oblikuj celice pogovorno okno, pojdite na Število jeziček, izberite po meri v Kategorija in vnesite [HH]: MM or [HH]: MM: SS v tip in na koncu kliknite OK . Oglejte si posnetek zaslona:
Zdaj je rezultat seštevanja časov prikazan v 24 urah, kot je prikazano spodaj.
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 7 months agoHey there, I am a beginner Excel user. I am trying to understand the use of double quotation mark for duration of time in formulas. Double quotation converts the numbers to text, right? But I am able to use it and it says as numbers in this formula; let's say there is 20:00:00, and I want to substract this from 30 hours. My formula would be ="30:00:00"-A2 and it works perfect! So here double quotation doesn't convert it to text. However, when I use double quotation in an IF formula inside a calculated field in pivottable, it doesn't work. For example: =IF('Field 1'>="1:00:00",1,0) Could you please explain and help me understand why I can not use double quotation in the if formula but I can use it when I substract it? I have been trying to understand this for 3 days... Going crazy. Thanks al lot...
To post as a guest, your comment is unpublished.· 1 years agohello my question is if i want to all time values in a specific cell and to restrict if time value is more than 24:00:00 then show dialog box error alert message etc Please any one help me...
To post as a guest, your comment is unpublished.· 11 months agoFormat to [h]:mm;@
It worked for me... took a while though!
To post as a guest, your comment is unpublished.· 2 years agoWhat would you use if you had to sum these? I just need the total hours but am unable to find a solution. Ideas?
To post as a guest, your comment is unpublished.· 2 years agoGood day,
Sorry can't help you with that.
To post as a guest, your comment is unpublished.· 2 years agoThank you!!
To post as a guest, your comment is unpublished.· 2 years agoAnd it save my problem also. So easy when you know how! :-)
To post as a guest, your comment is unpublished.· 3 years agoThis thread solved my problem. Thanks a lot