将秒数转换为小时和分钟 [英] Conversion of seconds to hours and minutes

问题描述

在另一篇需要转换的帖子中，我可以看到你是如何帮助这个人的，但是我的领域有点不同，而且编码不好。我的字段在报告中，并显示：= Sum（[Seconds]）。它由我需要转换的秒数之和组成。需要写什么才能把它变成几小时，几分钟和几秒钟？


谢谢，


Rio

In another post requiring conversion, I could see how you helped the person, but my field is a bit different and I do not code well. My field is on a report and reads: =Sum([Seconds]). It is comprised of the sum of the seconds that I need to convert. What needs to be written to turn it into hours, minutes and seconds?

Thank you,

Rio

推荐答案

我有一个建议但是它并不完美！你不需要编写它已经完成的功能！


=格式（Sum（[Seconds]）** 0.000694444444 / 60，" hh ：mm：ss"）

I have a proposal but it isn''t perfect! You don''t need to write functions it''s already done!


= format(Sum([Seconds])**0.000694444444/60,"hh:mm:ss")

Opa！


=格式（Sum（[Seconds]）* 0.000694444444 / 60，" hh：mm ：ss"）

你必须注意小数！如果你使用十进制virgul instaed点你可能有问题！

Opa!

= format(Sum([Seconds])*0.000694444444/60,"hh:mm:ss")
You have to pay attention with the decimal! If you use decimal virgul instaed point you may have problems!

Opa！


=格式（Sum（[Seconds]）* 0.000694444444 / 60，" hh：mm：ss"）

你必须注意小数！如果你使用十进制virgul instaed点你可能有问题！

Opa!

= format(Sum([Seconds])*0.000694444444/60,"hh:mm:ss")
You have to pay attention with the decimal! If you use decimal virgul instaed point you may have problems!

我复制并粘贴了字符串并收到错误消息：

"您输入的表达式包含无效语法。您可能输入了一个没有前面的值或标识符的逗号。


Rio

I copied and pasted the string and get an error that says:
"The expression you entered contains invalid syntax. You may have entered a comma without a preceeding value or identifier."

Rio

这篇关于将秒数转换为小时和分钟的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！