如何用Excel制作高考倒计时牌
发布网友
发布时间：2022-04-24 02:46
共5个回答
懂视网
时间：2022-06-29 00:49
1、在菜单栏上方点击“插入”，点击“图片”
2、自行选择高考倒计时的图片，可以在网上下载自己喜欢的格式，插入后自行调节图片大小
3、点击图片，上面的菜单栏会自动跳转至“图片工具”，点击“设置透明色”
4、用鼠标点击方框，你可以看到方框内变得透明，可以看到图片下的单元格
5、将图片移至一遍，自行根据图片中透明区域的大小调整单元格的大小
6、在H3（或者其他单元格都可以）处输入今天的日期，在调整好的单元格(H16)处输入公式“=H3-TODAY()”
7、点击回车即可，自行调节数字的大小
8、将刚刚设置好的图片移至单元格处，对准
热心网友
时间：2022-06-28 22:14
引用今天的函数=today（）
用高考日期-当前日期即是倒计时时间，并把单元格格式设置为常规即可，再设置漂亮一点即可，如下：
热心网友
时间：2022-06-28 23:49
<head>
<title>网页特效|Linkweb.cn/Js|---倒计时</title>
</head>
<BODY>
<!--将以下代码加入HTML的<Body></Body>之间-->
<SCRIPT language=JavaScript1.2>
function setcountdown(theyear,themonth,theday){
yr=theyear;mo=themonth;da=theday
}
setcountdown(2010,6,7)
var occasion="2010高考时间"
var message_on_occasion="盼望已久的时刻终于来到了!"
var countdownwidth='380px'
var countdownheight='40px'
var countdownbgcolor='tan'
var opentags='<font face="宋体"><small>'
var closetags='</small></font>'
var montharray=new Array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
var crosscount=''
function start_countdown(){
if (document.layers)
document.countdownnsmain.visibility="show"
else if (document.all||document.getElementById)
crosscount=document.getElementById&&!document.all?document.getElementById("countdownie") : countdownie
countdown()
}
if (document.all||document.getElementById)
document.write('<span id="countdownie" style="width:'+countdownwidth+'; background-color:'+countdownbgcolor+'"></span>')
window.onload=start_countdown
function countdown(){
var today=new Date()
var todayy=today.getYear()
if (todayy < 1000)
todayy+=1900
var todaym=today.getMonth()
var todayd=today.getDate()
var todayh=today.getHours()
var todaymin=today.getMinutes()
var todaysec=today.getSeconds()
var todaystring=montharray[todaym]+" "+todayd+", "+todayy+" "+todayh+":"+todaymin+":"+todaysec
futurestring=montharray[mo-1]+" "+da+", "+yr
dd=Date.parse(futurestring)-Date.parse(todaystring)
dday=Math.floor(dd/(60*60*1000*24)*1)
dhour=Math.floor((dd%(60*60*1000*24))/(60*60*1000)*1)
dmin=Math.floor(((dd%(60*60*1000*24))%(60*60*1000))/(60*1000)*1)
dsec=Math.floor((((dd%(60*60*1000*24))%(60*60*1000))%(60*1000))/1000*1)
if(dday<=0&&dhour<=0&&dmin<=0&&dsec<=1&&todayd==da){
if (document.layers){
document.countdownnsmain.document.countdownnssub.document.write(opentags+message_on_occasion+closetags)
document.countdownnsmain.document.countdownnssub.document.close()
}
else if (document.all||document.getElementById)
crosscount.innerHTML=opentags+message_on_occasion+closetags
return
}
else if (dday<=-1){
if (document.layers){
document.countdownnsmain.document.countdownnssub.document.write(opentags+"时间已经过了!"+closetags)
document.countdownnsmain.document.countdownnssub.document.close()
}
else if (document.all||document.getElementById)
crosscount.innerHTML=opentags+"Occasion already passed! "+closetags
return
}
else{
if (document.layers){
document.countdownnsmain.document.countdownnssub.document.write(opentags+dday+ " days, "+dhour+" hours, "+dmin+" minutes, and "+dsec+" seconds left until "+occasion+closetags)
document.countdownnsmain.document.countdownnssub.document.close()
}
else if (document.all||document.getElementById)
crosscount.innerHTML=opentags+"还有 "+dday+ " 天, "+dhour+" 小时, "+dmin+" 分, "+dsec+" 秒 就是 "+occasion+closetags
}
setTimeout("countdown()",1000)
}
</SCRIPT>
<ILAYER id=countdownnsmain visibility="hide" bgColor="&{countdownbgcolor};"
height="&{countdownheight};" width="&{countdownwidth};"><LAYER
id=countdownnssub height="&{countdownheight};"
width="&{countdownwidth};" top="0" left="0"></LAYER></ILAYER>
</body>
</html>
网页特效代码这个比较简单
热心网友
时间：2022-06-29 01:40
热心网友
时间：2022-06-29 03:48
可以做成PPT，加一些奋战高考的图片，更形象更有激励效果，vba编写的PPT网页链接
