C
Christy
To convert a numerical value to hours and minutes, you
said:
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!!!
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!!!