excel中小数形式度转化为度分秒形式1.-0.0100°所在单元格为P23.2.用公式 =INT(ROUND(P23,6))&" "&INT(ROUND((P23-INT(P23))*60,6))&" "&ROUND((((P23-INT(P23))*60-INT(ROUND((P23-INT(P23))*60,6)))*60),0)&" " 算出结果为-1 59 24.3.36
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 02:21:57
![excel中小数形式度转化为度分秒形式1.-0.0100°所在单元格为P23.2.用公式 =INT(ROUND(P23,6))&](/uploads/image/z/334112-32-2.jpg?t=excel%E4%B8%AD%E5%B0%8F%E6%95%B0%E5%BD%A2%E5%BC%8F%E5%BA%A6%E8%BD%AC%E5%8C%96%E4%B8%BA%E5%BA%A6%E5%88%86%E7%A7%92%E5%BD%A2%E5%BC%8F1.-0.0100%C2%B0%E6%89%80%E5%9C%A8%E5%8D%95%E5%85%83%E6%A0%BC%E4%B8%BAP23.2.%E7%94%A8%E5%85%AC%E5%BC%8F+%3DINT%28ROUND%28P23%2C6%29%29%26%22+%22%26INT%28ROUND%28%28P23-INT%28P23%29%29%2A60%2C6%29%29%26%22+%22%26ROUND%28%28%28%28P23-INT%28P23%29%29%2A60-INT%28ROUND%28%28P23-INT%28P23%29%29%2A60%2C6%29%29%29%2A60%29%2C0%29%26%22+%22+%E7%AE%97%E5%87%BA%E7%BB%93%E6%9E%9C%E4%B8%BA-1+59+24.3.36)
excel中小数形式度转化为度分秒形式1.-0.0100°所在单元格为P23.2.用公式 =INT(ROUND(P23,6))&" "&INT(ROUND((P23-INT(P23))*60,6))&" "&ROUND((((P23-INT(P23))*60-INT(ROUND((P23-INT(P23))*60,6)))*60),0)&" " 算出结果为-1 59 24.3.36
excel中小数形式度转化为度分秒形式
1.-0.0100°所在单元格为P23.
2.用公式 =INT(ROUND(P23,6))&" "&INT(ROUND((P23-INT(P23))*60,6))&" "&ROUND((((P23-INT(P23))*60-INT(ROUND((P23-INT(P23))*60,6)))*60),0)&" " 算出结果为-1 59 24.
3.36秒有科学计算器算得.
4.用excel怎样算出36秒?
如果将-0.01改为0.01,那么就能得到36秒,负数怎样计算呢?求通用的公式.
excel中小数形式度转化为度分秒形式1.-0.0100°所在单元格为P23.2.用公式 =INT(ROUND(P23,6))&" "&INT(ROUND((P23-INT(P23))*60,6))&" "&ROUND((((P23-INT(P23))*60-INT(ROUND((P23-INT(P23))*60,6)))*60),0)&" " 算出结果为-1 59 24.3.36
=IF(P23>0,TRUNC(P23)&"°"&TRUNC((P23-TRUNC(P23))*60)&"′"&TRUNC(((P23-TRUNC(P23))*60-TRUNC((P23-TRUNC(P23))*60))*60)&"""","-"&TRUNC(-P23)&"°"&TRUNC((-P23-TRUNC(-P23))*60)&"′"&TRUNC(((-P23-TRUNC(-P23))*60-TRUNC((-P23-TRUNC(-P23))*60))*60)&"""")
公式有点长,但能满足你的要求
显示方式:
-0.01 -0°0′36"
-1.91 -1°54′35"