sum for short time

[balahawy]

Hi all i create report and i want to sum field contains "short time hh:nn" but give me wrong result any suggestion

 

[GinaWhipp]

What formula are you using? Are you crossing midnight? Hmm, this might also help...
http://www.functionx.com/access/Lesson22.htm

 

[balahawy]

this is my formula

=DateDiff("h",[Dte],[Dte1]) & ":" & Round(((DateDiff("n",[Dte],[Dte1])/60)-DateDiff("h",[Dte],[Dte1]))*60,0)
and i show it as short time
example

Aug-02-2014 12:00:00 AM - Aug-01-2014 1:00:00 AM = 23 :00

 

[balahawy]

any news
i tried to show 1 entery in my report the time was 0:05 Min when i show it in the report it was 3.4722222222

 

[GinaWhipp]

Sorry for delay... it's was almost 4am when I typed that reply... I fell asleep!

Okay, so in looking in your example you want when you enter your time for it to show as Short Time even though that is not the way you are entering it?