conveying Time in an Excel sheet import

Rolando Macias
Tera Contributor

‎01-14-2022 05:52 AM

Hello,

 

I can't seem to get the correct format for time (Hrs,min,sec)  in my excel sheet to import in a service now report, I've tried every combination for time, it will not populate in the report,  this what I current have
find_real_file.png

they only thing I've managed to get working is,  for example the highlighted number above

 if I use 1.32 (see below)  that works in the report, But I'd really like to figure out how to display hours, minutes and seconds 
find_real_file.png
Please let me know what I'm doing wrong

Labels:
Preview file
11 KB
Preview file
23 KB
Preview file
12 KB
0 Helpfuls
  • 585 Views
2 REPLIES 2

bammar
Kilo Sage
Kilo Sage

‎01-15-2022 02:47 PM

if your using "EASY IMPORT" aka your right clicking and importing - Please go to transform maps( if your using load data youll also would have set up the Transform map yourself) - you will find a transform map - go to date field thats not looking right- you can actually adjust how the date field is imported in...

0 Helpfuls

Rolando Macias
Tera Contributor
In response to bammar

‎01-19-2022 07:42 AM

Bammar,

Thank you so much for your response but I only have limited reporting rights to create reports and when selecting a table I am selecting external source, so I'm note sure if I have or know how to find what you mean, do you know if there is a video or step by step diagrams that I can look at?
Thank you

0 Helpfuls