Excel Question - plotting timelines?

[GregE240]

Hi all,

I am currently documenting a number of backup jobs for a group of servers in a domain.

What I'd ideally like to achieve is a graphical timeline showing when server backups start and finish.

Does anyone know how I might go about this in Excel?


Thanks,
Greg

[shadytree]

Ask JohnRB, he's good with timelines.

[aldi]

Time in 15 minute chunks or whatever on one axis, one row per server on the other axis, coloured in bars representing jobs?

[GregE240]

Thanks for that, but the main problem I'm getting is that the backup jobs run overnight. Excel doesn't seem too happy with this.

[Jinx]

Not sure what the difficulty is can you provide some example data? My initial guess is that you need to use a date/time format not just a time format.

[ATG]

GregE240 said:

Thanks for that, but the main problem I'm getting is that the backup jobs run overnight. Excel doesn't seem too happy with this.

Do you mean the difficulty is caused by going past midnight?