how can i calculate time in a repot/

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to print 12 midnight inmilitary time 2400 hours. i will not print
out. i have to use 23;59pm
 
You could try an expression that returns a string like:
IIf([TimeField]=1,"24:00",Format([TimeField],"hh:nn"))
 
lasandrad said:
i need to print 12 midnight inmilitary time 2400 hours. i will not print
out. i have to use 23;59pm
Click to expand...


Midnight is 00:00

I suppose you could use some kind of expression to get 24:00
instead of 00:00. If you need help doing that, please post
a description of your time field/variable/expression. Is it
part of a date/time value?
 
You must log in or register to reply here.

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

Similar Threads

new record for new page of report 6
Time in calculated field for shifts going past midnight 0
HOW TO SHOW IMAGE FIELD (STORING IN SQL 2005) IN CRYSTAL REPORT 9 1
TIME CALCULATION 5
Calculate time difference 3
Access Access 2010 Time before and after midnight!!! 12
MS Graph: positioning items on x-axis 7
Time Calculation 6

Back
Top