Time Conversion follow-up

C

Christy

To convert a numerical value to hours and minutes, you
said:
Calculate the time difference in minutes. Then use this expression for what
you seek:

Result = (Minutes \ 60) & (Format(Minutes Mod 60, ":00")

what am I suppossed to put
for "Minutes"? i want it to automatically take whatever
value is in the numerical value column ([TRT])and convert
it into hours and minutes in the next column. This is the
formula I am using to calculate the difference in hours:

TRT: IIf([EndTime]>[StartTime],([EndTime]-[StartTime])
*24,24-([StartTime]-[EndTime])*24)

Is this suppossed to go inside your expression?

Please advise! Thank you!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top